Which dictionary view can you query to see if a tablespace is in "read only"?
Thanks!
05-07-2002, 02:22 PM
pando
dba_tablespaces?
05-07-2002, 02:46 PM
abongwa
NO.
STATUS
-------
ONLINE
The column is for online or offline.
05-07-2002, 03:18 PM
ndisang
YOU CAN DO
select tablespace_name from dba_tablespaces where status ='READ ONLY';
select status from dba_tablespaces where tablespace_name ='YOURTBS';
STATUS COLUMN IN DBA_TABLESPACES FLAG FOR ONLINE,OFFLINE,READ ONLY.
HOPE THIS HELPS
05-07-2002, 03:24 PM
pando
if you dont have a read-only tablespace how can you check for read-only tablesaces lol
05-07-2002, 03:34 PM
ndisang
Pando,
The guy wants to know which tbs is read only. So he searches for the unknown thus
select tablespace_name from dba_tablespaces where status ='READ ONLY';
look at his original post.
05-07-2002, 04:25 PM
abongwa
Thank you! That works!
05-07-2002, 04:38 PM
pando
you know that I first told him to look status column?
and he came back saying it's online or offline then it simply means that he only saw online/offline, in other words he has NO read-only tablespaces so I said how can you check for read-only tablespaces if you dont have any?
