Look in:

Web oracle-core-dba.blogspot.com

Friday, January 16, 2009

To calculate the export dump file size without actually exporting in Oracle 10G and above

Many times DBAs' may need to know the size of the export dump file size before starting the actual export of the database. This has become easy with the datapump option from Oracle version 10G.

Just give the following command:

expdp system full=y ESTIMATE_ONLY=Y NOLOGFILE=Y

for more options see

expdp help=y -- from your command prompt.

1 comment:

Ram DBA said...

Hi i want to know in normal export. can you please let me know.

Regards,
Ram