Friday, June 25, 2010

Find the Size of Schema in Database

Below query will help you out in finding the size of the schema in database


Select sum(bytes)/1024/1024/1024 GB, tablespace_name from dba_segments where owner='XXXXX' group by tablespace_name
NEED TO REPLACE XXXXX WITH THE SCHEMA NAME THAT NEEDS TO BE EXPORTED

No comments:

Post a Comment