Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

sde.st_domain_methods invalid after upgrade to 11.2.0.4

edited Mar 24, 2014 11:27AM in Database Install/Upgrade/Opatch (MOSC) 2 commentsAnswered ✓

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)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center