RE: ALTER TABLESPACE SYSAUX OFFLINE;

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Sun, 31 Jul 2005 00:22:08 +0200
Message-Id: <20050730222207.2BEEC1D93F7@turing.freelists.org>

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.

kind regards,

Lex.  

---

Steve Adams Seminar http://www.naturaljoin.nl/events/seminars.html

---

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

SQL> select open_mode,name from v$database;

OPEN_MODE NAME
---------- ---------

READ WRITE WIN2K10G
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Sat Jul 30 2005 - 17:24:02 CDT