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博客 ” ，链接：https://blog.itpub.net/19602/viewspace-1043472/ ，如需转载，请注明出处，否则将追究法律责任。
