SOLVED

ORA-39071: Value For EXCLUDE Is Badly Formed During Expdp

Asked by OracleDba••13 views•oracle
1
2
3
4
5
6
7
8
9
ORA-39071: Value For EXCLUDE Is Badly Formed During Expdp

Problem :

If you are trying to take export using exclude option from kshell prompt, then you may get an error as

ORA-39071

: Value for EXCLUDE is badly formed.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
expdp dumpfile=abc.dmp logfile=abc.log schemas=HELLOPDBA

directory=EXPORT exclude=TABLE:\"IN ('PVMERSADDRESS','VERSIONS')\""

Hope it Helps!
OracleDba•

Post Your Solution