how can I tell if a read only tablespace is offline?

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 31 Jan 2001 12:10:00 -0800
Message-ID: <F001.002A6232.20010131112712@fatcity.com>

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 Received on Wed Jan 31 2001 - 14:10:00 CST