Error:  ORA-31684 ‘Index already exists’ when importing ST_GEOMETRY spatial indexes using Oracle data pump utility (IMPDP).

【相关信息】
Article ID: 43327
Software:
ArcGIS for Desktop Advanced 10.3
ArcGIS for Desktop Standard 10.3
Platforms: N/A

【错误信息】
While importing the ST_GEOMETRY spatial indexes using the Oracle data pump utility (IMPDP), the following error messages may be returned:


Processing object type TABLE_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
"ORA-31684: Object type INDEX:"SDE"."A1_IX1" already exists"

"ORA-31684: Object type INDEX:"<OWNER>"."<SPATIAL_INDEX_NAME>" already exists"

"ORA-31684: Object type INDEX:"<OWNER>"."<SPATIAL_INDEX_NAME>" already exists"


Job "<IMP_USER>"."SYS_IMPORT_FULL_01" completed with <n> error(s) at <timestamp> elapsed 0 00:00:03


【错误原因】
For an ST_GEOMETRY spatial index the parameters, such as Spatial Reference ID (SRID), numeric characters of spatial grids, including the decimal symbol, are commonly different on the target database compared to those from the source database. Hence, during the import, the domain-specific implementation must create the index with new parameters.

However, the import process of the Oracle data pump utility is not aware of the index created by the domain-specific implementation, and it continues its attempt to create the index using original parameters stored from the source database. This causes the generation of the ORA-31684 'Index already exists' error.