Message-Id: <10758.127936@fatcity.com> From: Jacques Kilchoer Date: Wed, 31 Jan 2001 11:25:33 -0800 Subject: how can I tell if a read only tablespace is offline? This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C08BBB.945F1B60 Content-Type: text/plain; charset="iso-8859-1" I have two tablespaces that are read only. One is online, the other is offline. Does someone know of a query that will tell them apart? There doesn't seem to be any difference in dba_tablespaces or sys.ts$. SQL> alter tablespace read_only_online online ; Tablespace altered. SQL> alter tablespace read_only_offline offline ; Tablespace altered. SQL> select tablespace_name, status, contents 2 from dba_tablespaces 3 where tablespace_name in ('READ_ONLY_ONLINE', 'READ_ONLY_OFFLINE') ; TABLESPACE_NAME STATUS CONTENTS ------------------------------ --------- --------- READ_ONLY_OFFLINE READ ONLY PERMANENT READ_ONLY_ONLINE READ ONLY PERMANENT SQL> select name, online$, flags, spare1, spare2, spare3, spare4 2 from sys.ts$ 3 where name in ('READ_ONLY_ONLINE', 'READ_ONLY_OFFLINE') ; NAME ONLINE$ FLAGS SPARE1 SPARE2 SPARE3 SPARE4 ------------------------------ ------- ----- ------ ------ ---------- --------- READ_ONLY_OFFLINE 4 0 0 0 READ_ONLY_ONLINE 4 0 0 0 ------ any ignorant comments made are the sole responsibility of J. R. Kilchoer and should not reflect adversely upon my employer. Jacques R. Kilchoer (949) 754-8816 Quest Software, Inc. 8001 Irvine Center Drive Irvine, California 92618 U.S.A. http://www.quest.com ------_=_NextPart_001_01C08BBB.945F1B60 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable how can I tell if a read only tablespace is offline?

I have two tablespaces that are read only. One is = online, the other is offline. Does someone know of a query that will = tell them apart? There doesn't seem to be any difference in = dba_tablespaces or sys.ts$.

SQL> alter tablespace read_only_online online = ;

Tablespace altered.

SQL> alter tablespace read_only_offline offline = ;

Tablespace altered.

SQL> select tablespace_name, status, = contents
  2  from dba_tablespaces
  3  where tablespace_name in = ('READ_ONLY_ONLINE', 'READ_ONLY_OFFLINE') ;

TABLESPACE_NAME        =         STATUS    = CONTENTS
------------------------------ --------- = ---------
READ_ONLY_OFFLINE       &nbs= p;      READ ONLY PERMANENT
READ_ONLY_ONLINE        = ;       READ ONLY PERMANENT

SQL> select name, online$, flags, spare1, spare2, = spare3, spare4
  2  from sys.ts$
  3  where name in ('READ_ONLY_ONLINE', = 'READ_ONLY_OFFLINE') ;

NAME          = ;            = ;     ONLINE$ FLAGS SPARE1 SPARE2 = SPARE3     SPARE4
------------------------------ ------- ----- ------ = ------ ---------- ---------
READ_ONLY_OFFLINE       &nbs= p;            = 4     0      = 0      0
READ_ONLY_ONLINE        = ;            = ; 4     0      = 0      0


------
any ignorant comments made are the sole = responsibility of J. R. Kilchoer and should not reflect adversely upon = my employer.

 
Jacques R. Kilchoer
(949) 754-8816
Quest Software, Inc.
8001 Irvine Center Drive
Irvine, California 92618
U.S.A.