[Bug]IMPDP导入ArcSDE数据报：ORA-31693, ORA-02354, ORA-00600

最新推荐文章于 2025-02-26 17:44:25 发布

转载最新推荐文章于 2025-02-26 17:44:25 发布 · 9.7k 阅读

ArcSDE 同时被 3 个专栏收录

193 篇文章

订阅专栏

Oracle

106 篇文章

订阅专栏

用户典型问题

99 篇文章

订阅专栏

当使用Oracle11gR2数据泵导入包含ArcSDE10.x地理数据库的导出文件时，会出现ORA-31693、ORA-02354和ORA-00600等错误。本文介绍了错误的表现形式、受影响的Oracle版本以及提供了解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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

Description

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")], [], [], [], [], [], [], [], [], [], []"

Oracle 11.2.0.1.0 does not exhibit this behavior. Only versions 11.2.0.2.0 and 11.2.0.3.0 are affected.

Cause

This is a bug in Oracle:

Oracle Bug 14026888 - Datapump import gets ORA-600 [kpudpxcs_ctxConvertStream_ref_1] [ID 14026888.8].

Solution or Workaround

Download and apply Oracle Patch 16167942 prior to importing the dumpfile. Please contact Oracle Support to download and gather additional information about this patch.

Even with the Oracle patch applied, views are getting created with compilation errors upon import.

 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 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