Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

estimate size of tables/schema before expdp

G777Jun 14 2010 — edited Jun 14 2010

Hi *

(datapump SE 11g, Linux)

I'm trying to estimate the size of dump file before the export (due to unknown space and long running exports lest to run in vain).

I've used sofar "expdp ... estimate_only..." option but it's time consuming (times many exports I need to run) and it's not very accurate also.
I've queried bytes in dba_segments for selected owners, also irrelevant output COMPARING TO THE FINAL EXPORT DUMP SIZE.
I hope dba_tables/dba_indexes can provide more accurate data for calculations....(only this objects will be taken).

Please, share your ways to estimate as precisely as possible the size of dump file.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 12 2010

Added on Jun 14 2010

#general-database-discussions

4 comments

12,857 views