This parameter is useful when you wanted get the approximate size of the dump file. Suppose you have only limited space available in the disk and if you wanted to check whether your dump will be fit into the available space then you can use this parameter to check or estimate the size of the dump with doing the actual export. The default option for this parameter is ESTIMATE_ONLY=NO.
- You don’t need specify any of other parameters like directory, dumpfile etc.
Syntax :
ESTIMATE_ONLY=[YES | NO]
If ESTIMATE_ONLY=YES, then Export estimates the space that will consume but the export operation will not performed.
[oracle@18c empdata]$ expdp system/oracle TABLESPACES=USERS estimate_only=YES Export: Release 18.0.0.0.0 - Production on Fri Aug 24 22:51:52 2018 Version 18.3.0.0.0 Copyright (c) 1982, 2018, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production Starting "SYSTEM"."SYS_EXPORT_TABLESPACE_01": system/******** TABLESPACES=USERS estimate_only=YES Estimate in progress using BLOCKS method... Processing object type TABLE_EXPORT/TABLE/TABLE_DATA . estimated "SAM"."EMP" 2 MB . estimated "SAM"."SYS_EXPORT_SCHEMA_02" 1.75 MB . estimated "SAM"."SYS_EXPORT_SCHEMA_03" 1.75 MB . estimated "SAM"."SYS_EXPORT_SCHEMA_04" 1.75 MB . estimated "SAM"."SYS_EXPORT_SCHEMA_01" 320 KB Total estimation using BLOCKS method: 7.562 MB Job "SYSTEM"."SYS_EXPORT_TABLESPACE_01" successfully completed at Fri Aug 24 22:51:57 2018 elapsed 0 00:00:04
Catch Me On:- Hariprasath Rajaram
Telegram:https://t.me/joinchat/I_f4DhGF_Zifr9YZvvMkRg
LinkedIn:https://www.linkedin.com/in/hari-prasath-aa65bb19/
Facebook:https://www.facebook.com/HariPrasathdba
FB Group:https://www.facebook.com/groups/894402327369506/
FB Page: https://www.facebook.com/dbahariprasath/?
Twitter: https://twitter.com/hariprasathdba