Estimate the dumpfile size before taking Data pump export

If you want to estimate datapump file size then run following command

estimate datapump export size

datapump export file size



$ expdp "'/ as sysdba'" estimate_only=y full=Y


. estimated "SYSTEM"."REPCAT$_USER_AUTHORIZATIONS" 0 KB
. estimated "SYSTEM"."REPCAT$_USER_PARM_VALUES" 0 KB
. estimated "SYSTEM"."SQLPLUS_PRODUCT_PROFILE" 0 KB
Total estimation using BLOCKS method: 257.5 MB
Job "SYS"."SYS_EXPORT_FULL_01" successfully completed at 15:41:20