ESTIMATE REQUIRED DISK SPACE FOR EXPORT USING Estimate_only

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran Dalvi
  • 05 Sep, 2023
  • 0 Comments
  • 41 Secs Read

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. 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 Example : PARFILE WITH ESTIMATE OPTION:
cat exp_estimate.par

logfile=test.log
directory=EXPDIR
tables=TEST.TESTTABLE
ESTIMATE_ONLY=Y

EXPDP job:
expdp parfile=exp_estimate.par

Hope it Helps!