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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s