View to know read only tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: View to know read only tablespace

  1. #1
    Join Date
    Aug 2006
    Posts
    22

    View to know read only tablespace

    hi!
    im reading on read only tablespaces, what dynamic view would i know if a tablespace is read only? thanks sir/mam =)

  2. #2
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    status from dba_tablespaces
    ---------------

  3. #3
    Join Date
    Aug 2006
    Posts
    22
    hi!
    thanks! i keep looking on dba_data_files, so thats why there isnt no read only there ha9x, thanks again =)

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    thats because a datafile isnt a tablespace and is logically the wrong palce to look

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