Message-Id: <10758.127991@fatcity.com> From: Jacques Kilchoer Date: Wed, 31 Jan 2001 14:15:48 -0800 Subject: RE: 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_01C08BD3.5D418830 Content-Type: text/plain; charset="iso-8859-1" > -----Original Message----- > From: exu@nnng.com [mailto:exu@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 RE: how can I tell if a read only tablespace is offline?

> -----Original Message-----
> From: exu@nnng.com [mailto:exu@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