HowTo:  Upgrade an Oracle geodatabase after applying the Spatial Reference Consistency Patch

【解决方案】
After applying the Spatial Reference Consistency Patch, the geodatabase must be upgraded. The geodatabase upgrade detects and corrects any inconsistent spatial reference metadata. In addition, triggers are added to various geodatabase data dictionary objects to prevent spatial reference inconsistencies from being introduced by ArcGIS applications without the Spatial Reference Consistency Patch.

Even after executing the geodatabase upgrade, there may be situations in which feature classes with inconsistent spatial reference values must have their spatial indexes re-created.

If the spatial indexes are not re-created, one can encounter the following errors:

"Underlying DBMS error [ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE."

"Underlying DBMS error [ORA-29869: cannot issue ALTER without REBUILD on a domain index marked FAILED."


1. Determine which feature classes must have spatial indexes created. The following query returns any feature class that do not have a spatial index:

SELECT  owner, table_name

FROM sde.st_geometry_columns 

WHERE (owner, table_name, column_name) NOT IN 

  (SELECT owner, table_name, column_name 

   FROM sde.st_geometry_index);

The next query returns feature classes that currently have an invalid spatial index:

SELECT owner, table_name

FROM   all_indexes

WHERE  status <> 'VALID' 

AND    ityp_owner = 'SDE' 

AND    ityp_name = 'ST_SPATIAL_INDEX';  

This query does not return invalid indexes for which the user does not have privileges. It is recommended that the query be executed by a user with elevated permissions.
2. For each table returned, use ArcCatalog to drop and create the spatial index.


【其它相关参考】

1. ArcGIS 10.2.1 for (Desktop, Engine, Server) Spatial Reference Consistency Patch
2. ArcGIS 10.2.2 for (Desktop, Engine, Server) Spatial Reference Consistency Patch
3. KB42335: Invalid spatial reference (4326) set when inserting/updating the sde gdb_items table
4. KB42461: Unable to insert or update Oracle st_geometry feature classes, encountering ORA-20085 errors

【创建及修改时间】
Created: 6/19/2014

Last Modified: 6/24/2014
【原文链接】
http://support.esri.com/en/kno ... 42776