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:17:19 -0800
Message-ID: <F001.002A68EA.20010131141646@fatcity.com>

> -----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 Received on Wed Jan 31 2001 - 16:17:19 CST