DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: View to know read only tablespace

  1. 08-11-2006, 04:38 AM #1
    ehegagoka
    ehegagoka is offline Junior Member
    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 =)
    Reply With Quote Reply With Quote
  2. 08-11-2006, 04:51 AM #2
    reydp's Avatar
    reydp
    reydp is offline Senior Advisor
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    status from dba_tablespaces
    ---------------
    Reply With Quote Reply With Quote
  3. 08-11-2006, 05:10 AM #3
    ehegagoka
    ehegagoka is offline Junior Member
    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 =)
    Reply With Quote Reply With Quote
  4. 08-11-2006, 06:18 AM #4
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    thats because a datafile isnt a tablespace and is logically the wrong palce to look
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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