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 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
Joao

ORA-00600


Leave a Reply