-
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
-
Thanx
Sam
Life is a journey, not a destination!
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|