Warning: session_start(): open(/tmp/sess_hrif72vl3o2ol4i1hrfcmuu4e6, O_RDWR) failed: No space left on device (28) in /razi/eraazi/darbari/mercy/index.php on line 15
EraAzi | ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING estimate_only
 

ESTIMATE_ONLY parameter can be used in EXPDP command, to estimate the disk space required for the export job, without doing the actual export. So when we are not sure what will be the export dump size, then better to use this option first, before generating the export dump.

By default ESTIMATE_OPTION=N

DEMO:

PARFILE WITH ESTIMATE OPTION:

cat exp_estimate.par

logfile=exatree.log
directory=EXPDIR
tables=EXATREE.OBJECT_LIST
ESTIMATE_ONLY=Y

EXPDP job:

 expdp parfile=exp_estimate.par

Export: Release 12.1.0.2.0 - Production on Mon Nov 19 12:49:59 2018

Copyright (c) 1982, 2014, Oracle and/or its affiliates.  All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Starting "SYS"."SYS_EXPORT_TABLE_01":  /******** AS SYSDBA parfile=exp_estimate.par
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
.  estimated "EXATREE"."OBJECT_LIST"                       29 MB ---- >>>>>>>>>>> 
Total estimation using BLOCKS method: 29 MB
Job "SYS"."SYS_EXPORT_TABLE_01" successfully completed at Mon Nov 19 12:50:03 2018 elapsed 0 00:00:02

As it shows the estimation is 29 MB.

EXPDP BACKUP & RECOVERY