Problem: Importing an Oracle 11g R2 Data Pump file containing an ArcSDE 10.x geodatabase encounters Oracle errors ORA-31693, ORA-02354, ORA-00600
【相关信息】
Article ID: 41252
Bug Id: N/A
Software:
ArcSDE 10, 10.1
Platforms: N/A
【问题描述】
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 SDE schema from a 10.x geodatabase.
The import fails and reports the following error message:
The same problem also occurs when attempting to import a schema containing data stored in ST_GEOMETRY.
The import fails and reports the following error message:
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].
Article ID: 41252
Bug Id: N/A
Software:
ArcSDE 10, 10.1
Platforms: N/A
【问题描述】
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 SDE 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:
"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:
"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")], , , , , , , , , , "
【原因】
This is a bug in Oracle.
Oracle Bug 14026888 - Datapump import gets ORA-600 [kpudpxcs_ctxConvertStream_ref_1] [ID 14026888.8].
1 个回复
易智瑞技术支持
赞同来自:
This issue was addressed in Oracle 11G 11.2.0.3.0 PATCH 8 (for Windows).
Patch 14223717: ORACLE 11G 11.2.0.3 PATCH 8 BUG FOR WINDOWS 32 BIT
Patch 14223718: ORACLE 11G 11.2.0.3 PATCH 8 BUG FOR WINDOWS (64-BIT AMD64 AND INTEL EM64)
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.
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
【原文链接】
http://support.esri.com/en/kno ... 41252
要回复问题请先登录或注册