ORA-39201: Dump files are not supported for estimate only jobs.
Cause:
When i specify both dumpfile and estimate_only parameter in combination, an error is thrown
[oracle@dpprod ~]$ cat exp_sch_sh.par
userid='/ as sysdba'
directory=dpexp
dumpfile=exp_sch_sh_%U.dmp
logfile=exp_sch_sh.log
schemas=SH
filesize=3000M
parallel=8
estimate_only=y
Below is the error
[oracle@dpprod ~]$ expdp parfile=exp_sch_sh.par
Export: Release 12.1.0.2.0 - Production on Fri Oct 29 16:16:14 2021
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
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
ORA-39002: invalid operation
ORA-39201: Dump files are not supported for estimate only jobs.
Workaround:
Donot specify both dumpfile and estimate_only at the same execution because estimate_only is for getting an estimate of dump size without actually exporting dumpfile
expdp \'/ as sysdba\' tables=SH.DBSRC_BKP estimate_only=Y