PROBLEM
Importing an Oracle 11g R2 Data Pump export file containing a ArcSDE 10.x geodatabase fails with errors ORA-31693, ORA-02354, and ORA-00600.
The following example demonstrates using the Oracle Data Pump Import utility to import an Oracle export file containing just the schema from a 10.x geodatabase:
IMPDP system/system directory=IMPDP_DIR dumpfile=IMPDP_DIR:EXPDP_FULL.dmp schemas=SDE logfile=IMPDP_DIR:IMPDP_SDE.log job_name=IMPDP_SDE
The import fails and reports the following error message:
Error: "Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "SDE"."GDB_ITEMS" 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")], [], [], [], [], [], [], [], [], [], []"
The same problem also occurs when attempting to import a schema containing data stored in ST_GEOMETRY:
IMPDP system/system directory=IMPDP_DIR dumpfile=IMPDP_DIR:EXPDP_FULL.dmp schemas=MAP logfile=IMPDP_DIR:IMPDP_MAP.log job_name=IMPDP_MAP
The import fails and reports the following error message:
Error: Processing object type TABLE_EXPORT/TABLE/TABLE_DATA ORA-31693: Table data object "MAP"."PARCELS" 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")], [], [], [], [], [], [], [], [], [], []"
Note: Only Oracle versions 11.2.0.2.0 and 11.2.0.3.0 are affected by this.
This is a bug in Oracle:
Oracle Bug 14026888 - Datapump import gets ORA-600 [kpudpxcs_ctxConvertStream_ref_1] [ID 14026888.8].
This issue was addressed in Oracle 11G 11.2.0.3.0 PATCH 8 (for Windows).
Please contact Oracle Support to gather more information about this patch (if using Windows) or to obtain information about which patch is required when using a different operating system.
Oracle versions 11.2.0.4.0 and 12.1.0.1.0 do not exhibit this behavior.
Note: Even with the Oracle patch applied, views are created with compilation errors upon import.
Error: ORA-39082: Object type VIEW:"SDE"."GDB_ITEMS_VW" created with compilation warnings ORA-39082: Object type VIEW:"SDE"."GDB_ITEMRELATIONSHIPS_VW" created with compilation warnings
These problematic views can be fixed by manually compiling them or by executing the SYS.UTL_RECOMP package against the schema containing these erroneous views.
-------------------------------- -- Manually Compile the Views -- -------------------------------- SQL> ALTER VIEW SDE.GDB_ITEMS_VW COMPILE; View altered. SQL> ALTER VIEW SDE.GDB_ITEMRELATIONSHIPS_VW COMPILE; View altered. ---------------------------------------- -- Execute the SYS.UTL_RECOMP Package -- -- (run as the SYS User) -- ---------------------------------------- SQL> select object_name from dba_objects where status <> 'VALID' and owner = 'SDE'; OBJECT_NAME --------------------------------------- GDB_ITEMS_VW GDB_ITEMRELATIONSHIPS_VW 2 rows selected. SQL> EXEC SYS.UTL_RECOMP.RECOMP_SERIAL('SDE'); PL/SQL procedure successfully completed. SQL> select object_name from dba_objects where status <> 'VALID' and owner = 'SDE'; no rows selected
Get help from ArcGIS experts
Download the Esri Support App