which document? you can definitely take SYSAUX offline -- some stuff won't work, obviously :-) in Oracle 10g, you *must* have a SYSAUX tablespace, but you can take it offline, as you found out.
-- --Original Message-- -- From: oracle-l-bounce@(protected) [mailto:oracle-l-bounce@(protected)] On Behalf Of Sami Seerangan Sent: Saturday, July 30, 2005 20:35 To: oracle-l Subject: ALTER TABLESPACE SYSAUX OFFLINE;
I remember the document says that we cannot put SYSAUX in offline.
SQL> ALTER TABLESPACE SYSAUX OFFLINE;
Tablespace altered.
SQL> select * from v$version;
BANNER -- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ------ Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Prod PL/SQL Release 10.1.0.2.0 - Production CORE 10.1.0.2.0 Production TNS for 32-bit Windows: Version 10.1.0.2.0 - Production NLSRTL Version 10.1.0.2.0 - Production
