Database Administration (MOSC)

MOSC Banner

SYS.ODCIARGDESC, ODCICOLINFO, ODCICOST, ODCIINDEXINFO

edited Jun 5, 2009 4:32AM in Database Administration (MOSC) 4 commentsAnswered
 I am preparing to upgrade a database from 9.2.0.8 to 10.2.0.4.  The prep utility (utlu102i.sql) says that there are five objects owned by sys that are invalid.  I checked DBA_OBJECTS, and there are four types that are invalid:

ODCIARGDESC

ODCICOLINFO

ODCICOST

ODCIINDEXINFO

Can anyone tell me what these types are related to, and how to make them valid?  A simple

alter type sys.odciargdesc compile;

does not work.

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