-
Which dictionary view can you query to see if a tablespace is in "read only"?
Thanks!
-
-
NO.
STATUS
-------
ONLINE
The column is for online or offline.
-
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
Life is what is happening today while you were planning tomorrow.
-
if you dont have a read-only tablespace how can you check for read-only tablesaces lol
-
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.
Life is what is happening today while you were planning tomorrow.
-
-
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|