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:

The workaround to avoid this :

expdp dumpfile=pdp1037782.dmp logfile=pdp1037782.log schemas=HELLOPDBA 
directory=EXPORT exclude=TABLE:\"IN ('PVMERSADDRESS','VERSIONS')\""

 

SEE ALSO:

How to upgrade database from 11g to 12c manually

How to upgrade database using OEM 12 cloud control:

Crossplatform migration of database with zero downtime

Recover dropped table from rman backup ( new in 12c feature)

Convert non-partition table to partition table using EXCHANGE method: