Error 11g IMPDP ORA-39776 ORA-00600

May 20, 2010  |  dba

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”.

[oracle@app ~] expdp "'sys/xxxxxx as sysdba'" schemas=myschema dumpfile=dumpfilename.dmp compression=all

data is exported successfully.

[oracle@app ~] 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 “

ORA-00600: internal error code, arguments: [klaprs_11], [], [], [], [], [], [],

To fix the issue, you can apply patchset or upgrade to 11.2 release or apply oneoff Patch 6368018. Or, you can just export your data without the compression clause.



Leave a Reply