Tag: ora-01113
How to move tablespace to a new location
1) Take the tablespace offline
ALTER TABLESPACE tablespace-name OFFLINE;
2) Use the OS to Move the tablespace to the new location
3) Run the following command:
ALTER TABLESPACE tablespace-name RENAME DATAFILE ‘OS path to old tablespace\tablespace-datafile- name.dbf’ TO ‘OS path to new location\tablespace-datafile-name.dbf’;
4) Take the tablespace back online
ALTER TABLESPACE tablespace-name ONLINE;
If the following error is displayed
ORA-01113: file n [...]
Posted: December 18th, 2008 under Oracle.
Tags: alter tablespace, ora-01110, ora-01113, Oracle, recover, tablespace
Comments: none