RE: ALTER TABLESPACE SYSAUX OFFLINE;
- From: "Lex de Haan" <lex.de.haan@xxxxxxxxxxxxxx>
- To: <dba.orcl@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 31 Jul 2005 00:22:08 +0200
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:de Haan;Lex
FN:Lex de Haan
ORG:Natural Join B.V.
TEL;WORK;VOICE:+31.30.2515022
TEL;HOME;VOICE:+31.30.2518795
TEL;CELL;VOICE:+31.62.2955714
TEL;WORK;FAX:+31.30.2523366
ADR;WORK:;;Pieter Breughelstraat 10;Utrecht;;3583 SK;Netherlands
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:Pieter Breughelstraat 10=0D=0AUtrecht 3583
SK=0D=0ANetherlands
URL;WORK:http://www.naturaljoin.nl
EMAIL;PREF;INTERNET:lex.de.haan@xxxxxxxxxxxxxx
REV:20040224T160439Z
END:VCARD
Other related posts:
