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