Which dictionary view can you query to see if a tablespace is in

[abongwa]

Which dictionary view can you query to see if a tablespace is in "read only"?

Thanks!

[pando]

dba_tablespaces?

[abongwa]

NO.

STATUS
-------
ONLINE

The column is for online or offline.

[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

[pando]

if you dont have a read-only tablespace how can you check for read-only tablesaces lol

[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.

[abongwa]

Thank you! That works!

[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?