Estimate Size For Export Data Pump

In this entry  I like to show how to estimate the size for a data pump export. It is very easy because expdp command has a parameter to calculte. The problem is that this function, based in mi experiencie, no estimate very well but it is a starting  point. Here you have an example;

expdp system/xxx FULL=y ESTIMATE_ONLY=y ESTIMATE=blocks DIRECTORY=work_directory LOGFILE=EstimateFullSizeDump.log

HTHT – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s