Which dictionary view can you query to see if a tablespace is in
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

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

Hybrid View

  1. #1
    Join Date
    Feb 2002
    Posts
    59
    Which dictionary view can you query to see if a tablespace is in "read only"?

    Thanks!

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    dba_tablespaces?

  3. #3
    Join Date
    Feb 2002
    Posts
    59

    NO.

    STATUS
    -------
    ONLINE

    The column is for online or offline.

  4. #4
    Join Date
    Sep 2001
    Posts
    200
    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.

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you dont have a read-only tablespace how can you check for read-only tablesaces lol

  6. #6
    Join Date
    Sep 2001
    Posts
    200
    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.

  7. #7
    Join Date
    Feb 2002
    Posts
    59
    Thank you! That works!

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  



Click Here to Expand Forum to Full Width