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
