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 ?
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.