表空间脱机

表空间脱机需要在数据库打开的情况下进行，否则就会报错 

 

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

       

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