Today after I exported a schema and trying to import it to another schema (using remap_schema), I’ve hit the bug 6666291. The cause of this problem is an DataPump export file created with compression parameter set to “data_only” or “all”.
expdp “‘sys/xxxxxx as sysdba’” schemas=myschema dumpfile=dumpfilename.dmp compression=all
data is exported successfully.
impd dumpfile=dumpfilename.dmp remap_schema=myschema:otherschema
The errors I hit:
ORA-02354: error in exporting/importing data
ORA-39776: fatal Direct Path API error loading table “<table name>”
ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [],
To fix the issue, you can apply 11.1.0.7 patchset or upgrade to 11.2 release or apply oneoff Patch 6368018. Or, you can just export your data without the compression clause.
Regards
J
