Oracle Database Blog‎ > ‎Info pages‎ > ‎

Move or Rename Datafiles

-- Move or Rename DBF

SQL> SHUTDOWN IMMEDIATE

$ mv /OLD_LOCATION/db_file.dbf /NEW_LOCATION/db_file.dbf

SQL> STARTUP MOUNT

SQL> ALTER DATABASE RENAME FILE '/OLD_LOCATION/db_file.dbf' TO '/NEW_LOCATION/db_file.dbf';

SQL> ALTER DATABASE OPEN;