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

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 31 Jan 2001 11:25:33 -0800
Message-Id: <10758.127936@fatcity.com>

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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>how can I tell if a read only tablespace is offline?</TITLE>
</HEAD>
<BODY>

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       &nbsp= ;       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') ;


<FONT =

SIZE=3D2>NAME&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp; ONLINE$ FLAGS SPARE1 SPARE2 =

SPARE3     SPARE4
 ------------------------------ ------- ----- ------ =
------ ---------- ---------
 READ_ONLY_OFFLINE       &nbs= p;            = 4     0      = 0      0
 READ_ONLY_ONLINE       &nbsp= ;           &nbsp= ; 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.
 <A HREF=3D"http://www.quest.com" =
Received on Wed Jan 31 2001 - 13:25:33 CST