6.26.2012

Bug 14026888 - Datapump import gets ORA-600 [kpudpxcs_ctxConvertStream_ref_1] [ID 14026888.8] - ORA-31693,ORA-02354,ORA-00600

When a full database datapump import operations executed this morning to load data from an Oracle 11gR1 db to 11gR2 db, the job got failed with the following ORA errors on over 50 tables that has LOB data type:

ORA-31693: Table data object failed to load/unload & is being skipped due to
ORA-02354: error in exporting/importing data
ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1],  
              [SYS_TYPEID("SHAPE")

A very quick research about an ORA-600 error in the metalink brought the following facts and workaround to our knolwedge:



Affects:

Product (Component)Oracle Server (Rdbms)
Range of versions believed to be affected Versions BELOW 12.1
Versions confirmed as being affected
Platforms affectedGeneric (all / most platforms affected)

Fixed:

This issue is fixed in




Since there is no fix available yet, we applied the workaround, used conventional exp/imp, mentioned in the notes. Bravo, the workaround does worked and the issue got resolved..

Note : The BUG appears to be a generic one and applicable to all platforms.


1 comment:

Oracle apps said...

Hi

You are providing such a beautiful information which is useful for more readers as part of many services.I am the person following your blog thoroughly for more updates...Nice

Thanks & Regards,
Chandhu