更改DATAFILE位置

例子[@more@]

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/southdb/system01.dbf
/u01/app/oracle/oradata/southdb/tools01.dbf
/u01/app/oracle/oradata/southdb/rbs01.dbf
/u01/app/oracle/oradata/southdb/indx01.dbf
/u01/app/oracle/oradata/southdb/drsys01.dbf
/u01/app/oracle/oradata/southdb/rbs02.dbf
/u01/app/oracle/oradata/southdb/rbs03.dbf
/u01/app/oracle/oradata/southdb/rbs04.dbf

8 rows selected.

SQL> alter tablespace users read only;
alter tablespace users read only
*
ERROR at line 1:
ORA-00959: tablespace 'USERS' does not exist

SQL> alter tablespace tools read onlyl
2 ;
alter tablespace tools read onlyl
*
ERROR at line 1:
ORA-02142: missing or invalid ALTER TABLESPACE option

SQL> alter tablespace tools read only;

Tablespace altered.

SQL> !cp /u01/app/oracle/oradata/southdb/tools01.dbf /u01/app/oracle/oradata/tools01.dbf

SQL> alter tablespace tools offline;

Tablespace altered.

SQL> alter database rename file '/u01/app/oracle/oradata/southdb/tools01.dbf' to '/u01/app/oracle/oradata/tools01.dbf';

Database altered.

SQL> alter tablespace tools online;

Tablespace altered.

SQL> alter tablespace tools read write;

Tablespace altered.

SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/southdb/system01.dbf
/u01/app/oracle/oradata/tools01.dbf
/u01/app/oracle/oradata/southdb/rbs01.dbf
/u01/app/oracle/oradata/southdb/indx01.dbf
/u01/app/oracle/oradata/southdb/drsys01.dbf
/u01/app/oracle/oradata/southdb/rbs02.dbf
/u01/app/oracle/oradata/southdb/rbs03.dbf
/u01/app/oracle/oradata/southdb/rbs04.dbf

8 rows selected.

SQL>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9925929/viewspace-966425/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9925929/viewspace-966425/