ALTER TABLESPACE SYSAUX OFFLINE;

From: Sami Seerangan <dba.orcl_at_gmail.com>
Date: Sat, 30 Jul 2005 14:34:57 -0400
Message-ID: <f09dd628050730113470b04789@mail.gmail.com>

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 Received on Sat Jul 30 2005 - 13:36:50 CDT