sde.st_domain_methods invalid after upgrade to 11.2.0.4
I completed the upgrade of oracle from 11.2.0.1 to 11.2.0.4 (Linux 6). Running @?/rdbms/admin/utluiobj.sql:
Oracle Database 11.2 Post-Upgrade Invalid Objects Tool 03-22-2014 08:07:47
.
This tool lists post-upgrade invalid objects that were not invalid
prior to upgrade (it ignores pre-existing pre-upgrade invalid objects).
.
Owner Object Name Object Type
.
SDE ST_DOMAIN_METHODS TYPE BODY
PL/SQL procedure successfully completed.
SQL> alter type sde.ST_DOMAIN_METHODS compile body;
Warning: Type Body altered with compilation errors.
SQL> show err
Errors for TYPE BODY SDE.ST_DOMAIN_METHODS:
LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 PLS-00907: cannot load library unit SDE.SPX_UTIL (referenced by
SDE.ST_TYPE_EXPORT)