Renaming and Relocating of an oracle data file

We can move or rename oracle data file while the data file is online/offline using the ALTER DATABASE MOVE DATAFILE command.

Examples:

1.  Renaming an online data file:

   SQL> alter database move datafile '/u01/dbfile/ora12/users01.dbf' to '/u01/dbfile/ora12/users.dbf';

2. Moving a data file to a new mount point:

   SQL> alter database move datafile '/u01/dbfile/ora12/users.dbf' to '/u02/dbfile/ora12/users.dbf';

3. You can also specify the data file number when renaming or moving a data file:

   SQL> alter database move datafile 3 to '/u01/dbfile/ora12/users.dbf';

4.  If you want to keep a copy of the original file, you can use the KEEP option:

   SQL> alter database move datafile 4 to '/u01/dbfile/ora12/users.dbf' keep;