ALTER TABLESPACE SYSAUX OFFLINE; 2005-07-30 - By Sami Seerangan
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
|
|
