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:
Post a Comment