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

From: Jacques Kilchoer <Jacques.Kilchoer_at_quest.com>
Date: Wed, 31 Jan 2001 14:15:48 -0800
Message-Id: <10758.127991@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_01C08BD3.5D418830
Content-Type: text/plain;

charset="iso-8859-1"

> -----Original Message-----
> From: exu_at_nnng.com [mailto:exu_at_nnng.com]
> Sent: mercredi, 31. janvier 2001 12:57 
> 
> I believe that  the status column from v$datafile_header 
> table will  tell them
> apart. For the read only tablespace which is put offline, you 
> will see no record
> returned, and for the read only tablespace which is put 
> online, it will tell you
> that this tablespace is online.
> The status column in the dba_tablespaces view will only tell 
> you if this
> tablespace is read only or read write.

Thank you, also v$datafile will tell you which datafiles are offline. I was thinking that the information would be available at the tablespace level though but I guess it isn't.

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_01C08BD3.5D418830
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>RE: how can I tell if a read only tablespace is offline?</TITLE>
</HEAD>
<BODY>

> -----Original Message-----
 > From: exu_at_nnng.com [<A =
HREF=3D"mailto:exu_at_nnng.com">mailto:exu_at_nnng.com</A>]
 > Sent: mercredi, 31. janvier 2001 12:57 
 > 
 > I believe that  the status column from =
v$datafile_header 
 > table will  tell them
 > apart. For the read only tablespace which is =
put offline, you 
 > will see no record
 > returned, and for the read only tablespace =
which is put 
 > online, it will tell you
 > that this tablespace is online.
 > The status column in the dba_tablespaces view =
will only tell 
 > you if this
 > tablespace is read only or read write.


Thank you, also v$datafile will tell you which =
datafiles are offline. I was thinking that the information would be = available at the tablespace level though but I guess it = isn't.

------
 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" =
TARGET=3D"_blank">http://www.quest.com</A> Received on Wed Jan 31 2001 - 16:15:48 CST