sysaux表空间的一些测试

   （一）数据库处于mount不能设置表空间sysaux脱机

         

SQL> startup mount
ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance
ORACLE instance started.

Total System Global Area 1185927168 bytes
Fixed Size      2227744 bytes
Variable Size    603980256 bytes
Database Buffers   570425344 bytes
Redo Buffers      9293824 bytes
Database mounted.

 

 SQL> alter tablespace sysaux offline;
alter tablespace sysaux offline
*
ERROR at line 1:
ORA-01109: database not open   

 

      (二)数据库打开状态下能设置表空间脱机

               

      SQL> alter tablespace sysaux offline;

         Tablespace altered.

 

     (三)不能删除sysaux表空间

                   

SQL> drop tablespace sysaux including contents and datafiles;
drop tablespace sysaux including contents and datafiles
*
ERROR at line 1:
ORA-13501: Cannot drop SYSAUX tablespace

 

 

   （四）不能设置sysaux只读

          SQL> alter tablesapce SYSAUX read only;
alter tablesapce SYSAUX read only
      *
ERROR at line 1:
ORA-00940: invalid ALTER command

 

（五)sysaux表空间不能重命明

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