Please see my other blog for Oracle EBusiness Suite Posts - EBMentors

Search This Blog

Note: All the posts are based on practical approach avoiding lengthy theory. All have been tested on some development servers. Please don’t test any post on production servers until you are sure.

Tuesday, June 26, 2012

Datapump import gets ORA-600 [kpudpxcs_ctxConvertStream_ref_1] while importing Spatial data

Working for one of our client , just got the below error in impdp log for some tables, one example below.

ORA-31693: Table data object "GDB"."STREETS" failed to load/unload and is being
skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00600: internal error code, arguments: [kpudpxcs_ctxConvertStream_ref_1],
 [SYS_TYPEID("SHAPE")], [], [], [], [], [], [], [], [], [], []
A quick search on metalink revealed the fact that is it bug (generic)
(Bug 14026888  Datapump import gets ORA-600 [kpudpxcs_ctxConvertStream_ref_1]

and workaround is to Use conventional export / import. But as we already had run the
datapump import successfully for the most of the tables, so just we took the complete
traditional export (exp) and then import those specific tables using traditional import
(imp )with ignore=y as tables had already been created in the datapump import process.
 
It worked with success :)

 
Ref: 14026888.8, 1411854.1 

No comments: