- 11 Dec, 2023
- 0 Comments
- 15 Secs Read
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.Solution :
expdp dumpfile=abc.dmp logfile=abc.log schemas=HELLOPDBA
directory=EXPORT exclude=TABLE:\"IN ('PVMERSADDRESS','VERSIONS')\""