system表空间不可改名

SQL> startup mount;
ORACLE instance started.

Total System Global Area  814227456 bytes
Fixed Size                  2257640 bytes
Variable Size             528485656 bytes
Database Buffers          281018368 bytes
Redo Buffers                2465792 bytes
Database mounted.
SQL> alter tablespace system rename to system01;
alter tablespace system rename to system01
*
ERROR at line 1:
ORA-01109: database not open


SQL> alter database open;

Database altered.

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

SQL> 

本文转自健哥的数据花园博客园博客，原文链接：http://www.cnblogs.com/gaojian/p/3646901.html，如需转载请自行联系原作者