ITPub博客

首页 > 应用开发 > IT综合 > 更改DATAFILE位置

更改DATAFILE位置

原创 IT综合 作者:OmarChina 时间:2007-08-28 09:40:44 0 删除 编辑
例子[@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博客 ” ,链接:https://blog.itpub.net/9925929/viewspace-966425/ ,如需转载,请注明出处,否则将追究法律责任。

上一篇: Linstener启动过慢
下一篇: kill session
请登录后发表评论 登录
全部评论
  • 博文量
    68
  • 访问量
    1008514