<<Back to Oracle DATAPUMP Main Page
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00907: missing right parenthesis
$ expdp system@orcl parfile=EXP_FULL_DB.parExport: Release 12.1.0.2.0 - Production on Mon Oct 8 11:12:48 2018
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.
Password:
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, Oracle Label Security,
OLAP, Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-39071: Value for EXCLUDE is badly formed.
ORA-00907: missing right parenthesis
Solution:
Check and correct syntax in the exclude parameter in your par file.
Correct Exclude Syntax
EXCLUDE=object_type[:name_clause] [, ...]
Examples:
Example1: Excluding the tables returned in select statement
directory=ASM_DUMP
dumpfile=FULL_%U.dmp
FILESIZE=10G
full=y
EXCLUDE=TABLE:"IN(select table_name from dba_tables where table_name in ('TEST1',
'LOGT',
'DATAX'))"
Example2: Excluding the Selective Indexes
directory=ASM_DUMP
dumpfile=FULL_%U.dmp
FILESIZE=10G
full=y
EXCLUDE=INDEX:"LIKE 'EMP%' "
Example3: Excluding an schema
directory=ASM_DUMP
dumpfile=FULL_%U.dmp
FILESIZE=10G
full=y
exclude=schema: "IN ('WMSYS', 'OUTLN')"
dumpfile=FULL_%U.dmp
FILESIZE=10G
full=y
exclude=schema: "IN ('WMSYS', 'OUTLN')"
Comments
Post a Comment