表空间脱机需要在数据库打开的情况下进行,否则就会报错
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