PROBLEM
After upgrading an ArcSDE for Oracle geodatabase and revoking the upgrade privileges, the SQL access to spatial data using ST_GEOMETRY operators may fail with the following errors:"ORA-29900: operator binding does not exist""ORA-06540: PL/SQL: compilation error""ORA-06553: PLS-907: cannot load library unit SDE.ST_GEOMETRY_OPERATORS"or"ORA-06553: PLS-907: cannot load library unit SDE.ST_GEOM_UTIL"
When this privilege is revoked from the SDE admin user after upgrading a geodatabase,
SELECT ANY TABLE
Exec dbms_utility.compile_schema( 'SDE', compile_all => FALSE );
Article ID:000010957
Get help from ArcGIS experts
Download the Esri Support App