<<Back to Oracle DATAPUMP Main Page
expdp ESTIMATE_ONLY=Y
To estimate the space requirement for an export use ESTIMATE_ONLY parameterDefault: NO
Syntax and Description
ESTIMATE_ONLY=[YES | NO]
If ESTIMATE_ONLY=YES, then Export estimates the space that would be consumed, but quits without actually performing the export operation.
ESTIMATE_ONLY by default usage parameter ESTIMATE=BLOCKS. But if you want to use STATISTICS instead of BLOCKS for required space calculation use ESTIMATE=STATISTICS together with ESTIMATE_ONLY=Y
For ESTIMATE=STATISTICS to calculate accurate space requirement all tables should have been analyzed recently.
Note: DUMPFILE parameter together with ESTIMATE_ONLY is not supported and you will receive below error if you use it together, therefore while using ESTIMATE_ONLY=Y comment out DUMPFILE parameter in the export par file
ORA-39002: invalid operation
ORA-39201: Dump files are not supported for estimate only jobs.
$ cat exp_full_pdb01.par
#DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
SCHEMAS=TEST
REUSE_DUMPFILES=Y
ESTIMATE_ONLY=Y
$expdp system@PDB01 parfile=exp_full_pdb01.par
Export: Release 12.2.0.1.0 - Production on Tue Oct 23 11:41:02 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@PDB01 parfile=exp_full_pdb01.par
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. estimated "TEST"."PEOPLE" 64 KB
Total estimation using BLOCKS method: 64 KB
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Oct 23 11:41:26 2018 elapsed 0 00:00:19
$ cat exp_full_pdb01.par
DIRECTORY=DUMP
#DUMPFILE=EXP_PDB01_FULL%U.DMP
LOGFILE=EXP_PDB01_FULL.LOG
SCHEMAS=TEST
REUSE_DUMPFILES=Y
ESTIMATE_ONLY=Y
ESTIMATE=STATISTICS
$ expdp system@PDB01 parfile=exp_full_pdb01.par
Export: Release 12.2.0.1.0 - Production on Tue Oct 23 11:42:21 2018
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Starting "SYSTEM"."SYS_EXPORT_SCHEMA_01": system/********@PDB01 parfile=exp_full_pdb01.par
Estimate in progress using STATISTICS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. estimated "TEST"."PEOPLE" 6.583 KB
Total estimation using STATISTICS method: 6.583 KB
Job "SYSTEM"."SYS_EXPORT_SCHEMA_01" successfully completed at Tue Oct 23 11:42:34 2018 elapsed 0 00:00:10
Comments
Post a Comment