How to Rename or Move Oracle Tablespace Datafile to Another Location

Posted on April 3, 2013 by admin
  • Login to SQLPlus.
  • Connect as SYS DBA with CONNECT / AS SYSDBA command.
  • Make offline the affected tablespace with ALTER TABLESPACE <tablespace name> OFFLINE; command.
  • Modify the name or location of datafiles in Oracle data dictionary using following command syntax:

ALTER TABLESPACE <tablespace name> RENAME DATAFILE ‘<fully qualified path to original data file name>’ TO ‘<new or original fully qualified path to new or original data file name>’;

  • Bring the tablespace online again with ALTER TABLESPACE alter tablespace <tablespace name> ONLINE; command.
This entry was posted in Oracle. Bookmark the permalink.