Hello All!
I have another question for you.. probably a newbie question too... what is a good statement to use to find out how much space is used by a particular schema?
Thanks
Printable View
Hello All!
I have another question for you.. probably a newbie question too... what is a good statement to use to find out how much space is used by a particular schema?
Thanks
I think "select sum(bytes) from dba_segments where owner='SCHEMA'" should work.
Find out what are all the data and index tablespaces used for that particular schema(If you have designed your schema like that) and calculate the total. Get the information you wanted from DBA_TABLESPACES and DBA_FREE_SPACE views.
You can see the size of tablespace if you are using Oracle Enterprize Manager/ any other third party enterprize management tool.
Powneil statement works. Thats Quick tip. thanks
[Edited by sreddy on 01-03-2001 at 03:09 PM]
thanks for your help guys!