ALTER TABLESPACE SYSAUX OFFLINE;

  • From: Sami Seerangan <dba.orcl@xxxxxxxxx>
  • To: oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 30 Jul 2005 14:34:57 -0400

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


SQL> select open_mode,name from v$database;

OPEN_MODE  NAME
---------- ---------
READ WRITE WIN2K10G
--
http://www.freelists.org/webpage/oracle-l

Other related posts: