Table / Schema Size ??

[netlurch]

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

[sambavan]

Check the dba_tables http://www.oradoc.com/ora817/server....ch293.htm#8346

Sam

[netlurch]

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