Calculating schema size
285909Aug 12 2008 — edited Aug 12 2008Hello.
I'm trying to calculate the size of a schema.
If I use the following statement:
SELECT SUM(bytes)/1024/1024/1024 AS size_gig FROM DBA_SEGMENTS WHERE OWNER= 'XXX';
then i'm getting a different result compared to calculating the size using EXPDP like this:
c:\expdp estimate_only=y schemas=xxx
The difference is about 10 gigybytes, which is enourmous.
Any ideas how I can get the correct size?
Regards,
Matthias