Re: How to fix the INVALID dba_objects

Hi Vladimir,

You're absolutely right, this is a bug was introduced from 9.2.0.x, perhaps starting in 9.2.0.4, then it was fixed in 9.2.0.5, but it re-introduced in 9.2.0.6 with bug #2782260, I discovered these INVALID objects when I upgraded my database from 9.2.0.1 to 9.2.0.6, these INVALID objects have the OBJECT_TYPE = TYPE in DBA_OBJECTS, these are duplicated rows in both USER_TYPE_METHOD and DBA_OBJECTS with INVALID STATUS. By the way this issue is fixed in 10g, I upgraded my database to 10g and all the INVALID object were gone.

Thank you very much,
Vance Received on Wed May 03 2006 - 16:04:41 CDT