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.
Eveleen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
