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

How can I remove a URL on my website from the Google Index?

To remove a specific URL (for example, the page http://www.example.com/page4.html) of your own website from Google’s index, there are two ...