How to fix the INVALID dba_objects

From: <vwu_at_anacomp.com>
Date: 1 May 2006 20:25:41 -0700
Message-ID: <1146540341.426997.77150@i40g2000cwc.googlegroups.com>

Hi,

My database is 9.2.0.6, I ran utlirp.sql many times, but the following 'INVALID' objects still there:

SQL> SELECT distinct object_name FROM dba_objects WHERE status='INVALID';

OBJECT_NAME

---

ODCIARGDESC
ODCICOLINFO
ODCICOST
ODCIINDEXINFO SQL> I also found these INVALID objects are duplicated rows in dba_objects, for example:

SQL> select object_name, status from dba_objects where object_name ='ODCIARGDESC';

OBJECT_NAME            STATUS
-----------            ---------
ODCIARGDESC            INVALID
ODCIARGDESC            VALID

SQL> Can someone tell me how to fix the above invalid objects, I also ran catalog.sql and catproc.sql, but it didn't help.

Thanks,
Vance Received on Mon May 01 2006 - 22:25:41 CDT