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"
"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 );