Monday, 30 July 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 versionsbelieved to be affectedVersions BELOW 12.1
Versionsconfirmed 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.

No comments:

Post a Comment