> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> 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
