ITPub博客

首页 > 应用开发 > IT综合 > sysaux和system不支持重命名!

sysaux和system不支持重命名!

原创 IT综合 作者:warehouse 时间:2010-12-22 23:08:21 0 删除 编辑
2个系统表空间不支持重命名...[@more@]

SQL> alter tablespace system rename to system1;
alter tablespace system rename to system1
*
ERROR at line 1:
ORA-00712: cannot rename system tablespace


SQL> show parameter undo

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
undo_management string AUTO
undo_retention integer 900
undo_tablespace string UNDOTBS2
SQL> alter tablespace undotbs2 rename to undotbs1;

Tablespace altered.

SQL> alter tablespace sysaux rename to sysaux1;
alter tablespace sysaux rename to sysaux1
*
ERROR at line 1:
ORA-13502: Cannot rename SYSAUX tablespace


SQL> alter tablespace temp rename to temp1;

Tablespace altered.

SQL>

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

请登录后发表评论 登录
全部评论

注册时间:2007-12-07

  • 博文量
    717
  • 访问量
    5099640