SQL> select count(*) from all_objects 2 where status = 'VALID';
COUNT(*) -- ---- -- 48887
SQL>
-- -- Original Message -- -- From: "Sami Seerangan" <dba.orcl@(protected)> To: "oracle-l" <oracle-l@(protected)> Sent: Sunday, July 31, 2005 2:34 AM 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 >
