Table / Schema Size ??
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Table / Schema Size ??

Hybrid View

  1. #1
    Join Date
    Jun 2001
    Posts
    2

    Question

    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 ?

    -Jon

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Thanx
    Sam



    Life is a journey, not a destination!


  3. #3
    Join Date
    Jun 2001
    Posts
    2
    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.

    -Jon



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