SELECT * FROM DBA_DATA_FILES
select * from dba_temp_files
SQL> alter tablespace my_TABLESPACE read only;
SQL> !cp -p /data/oradata/ndrs/my_TABLESPACE01.dbf /opt/oracle/ndrs/.
SQL> alter tablespace my_TABLESPACE offline;
SQL> alter database rename file '/data/oradata/ndrs/my_TABLESPACE01.dbf' to '/opt/oracle/ndrs/my_TABLESPACE01.dbf';
SQL> alter tablespace my_TABLESPACE online;
SQL> alter tablespace my_TABLESPACE read write;
SQL> alter database backup controlfile to trace;
SQL> !rm /data/oradata/ndrs/my_TABLESPACE01.dbf
ALTER DATABASE
DATAFILE '/opt/oracle/ndrs/my_TABLESPACE01.dbf' RESIZE 800M
[@more@]
select * from dba_temp_files
SQL> alter tablespace my_TABLESPACE read only;
SQL> !cp -p /data/oradata/ndrs/my_TABLESPACE01.dbf /opt/oracle/ndrs/.
SQL> alter tablespace my_TABLESPACE offline;
SQL> alter database rename file '/data/oradata/ndrs/my_TABLESPACE01.dbf' to '/opt/oracle/ndrs/my_TABLESPACE01.dbf';
SQL> alter tablespace my_TABLESPACE online;
SQL> alter tablespace my_TABLESPACE read write;
SQL> alter database backup controlfile to trace;
SQL> !rm /data/oradata/ndrs/my_TABLESPACE01.dbf
ALTER DATABASE
DATAFILE '/opt/oracle/ndrs/my_TABLESPACE01.dbf' RESIZE 800M
[@more@]
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/205087/viewspace-793133/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/205087/viewspace-793133/