[root@localhost ~]# su - oracle[oracle@localhost ~]$ lsnrctl startSQL> conn /as sysdbaConnected to an idle instance.SQL> select file_name from sys.dba_data_files;FILE_NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/yuchunju/users01.dbf/u01/app/oracle/oradata/yuchunju/undotbs01.dbf/u01/app/oracle/oradata/yuchunju/sysaux01.dbf/u01/app/oracle/oradata/yuchunju/system01.dbf/u01/app/oracle/oradata/yuchunju/example01.dbf[root@localhost yuchunju]# cp users01.dbf test.dbf   //以防万一[root@localhost yuchunju]# mkdir /u01/data[root@localhost yuchunju]# mv users01.dbf /u01/data/SQL> conn /as sysdbaConnected to an idle instance.SQL> startup mountORACLE instance started.Total System Global Area 1653518336 bytesFixed Size		    2213896 bytesVariable Size		  973080568 bytesDatabase Buffers	  671088640 bytesRedo Buffers		    7135232 bytesDatabase mounted.SQL> alter database rename file '/u01/app/oracle/oradata/yuchunju/users01.dbf' to '/u01/data/users01.dbf';Database altered.SQL> alter database open;Database altered.SQL> select file_name from sys.dba_data_files;FILE_NAME--------------------------------------------------------------------------------/u01/data/users01.dbf/u01/app/oracle/oradata/yuchunju/undotbs01.dbf/u01/app/oracle/oradata/yuchunju/sysaux01.dbf/u01/app/oracle/oradata/yuchunju/system01.dbf/u01/app/oracle/oradata/yuchunju/example01.dbf数据库文件移动成功。再测试一个/u01/app/oracle/oradata/yuchunju/sysaux01.dbf[root@localhost data]# mkdir /u02/data[root@localhost data]# chown -R oracle:oinstall /u02首先要关闭数据库SQL> shutdown immediate然后移动数据文件[root@localhost data]# mv /u01/app/oracle/oradata/yuchunju/sysaux01.dbf /u02/data/等待数据库装载SQL> startup mount 通过alter语句，修改文件路径和名称。完成后打开数据库SQL>alter database rename file '/u01/app/oracle/oradata/yuchunju/sysaux01.dbf' to '/u02/data/sysaux01.dbf';打开数据库SQL>alter database open;SQL> select file_name from sys.dba_data_files;FILE_NAME--------------------------------------------------------------------------------/u01/data/users01.dbf/u01/app/oracle/oradata/yuchunju/undotbs01.dbf/u02/data/sysaux01.dbf/u01/app/oracle/oradata/yuchunju/system01.dbf/u01/app/oracle/oradata/yuchunju/example01.dbf