DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2001


    We have a content engine that we have built for clients. They enter content via the web and it generates and feeds their website(s).

    I need to be able to somehow query a schema and 'see' how much space they are using. I saw some other posts on grabbing the entire database size set aside as well as size used, but I need to go one step further and look at the size of a particular schema. I have one particular table 'content' that has a LONG field that the VSIZE won't seem to work on ... ( ORA-00997: illegal use of LONG datatype )

    Any ideas ?


  2. #2
    Join Date
    Oct 2000
    Saskatoon, SK, Canada

    Life is a journey, not a destination!

  3. #3
    Join Date
    Jun 2001
    Thanks for the link. I checked dba_tables for a particular owner. All the tables are there (obviously), but I don't have any values in blocks for any tables etc.

    Thanks anyway.


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.