Prior to 12c, the process to rename/relocate a data file consisted off
- taking the tablespace offline
- renaming the datafiles using OS commands
- issuing an
ALTER TABLESPACE data_01
RENAME DATAFILE '/u01/oradata/data_01.dbf' TO '/u02/oradata/data_01.dbf';
- bring the table space online
With 12c, this is much easier. You can accomplish this with:
ALTER DATABASE MOVE DATAFILE '/u01/oradata/data_01.dbf' TO '/u02/oradata/data_01.dbf';