sysaux和system不支援重新命名!

warehouse發表於2010-12-22
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/,如需轉載,請註明出處,否則將追究法律責任。

相關文章