| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: how can I tell if a read only tablespace is offline?
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: exu_at_nnng.com
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: ListGuru_at_fatcity.com (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). Received on Wed Jan 31 2001 - 16:52:26 CST
 |
 |