Re: How to fix the INVALID dba_objects

The appropriate strategy for fixing these objects will require a little more info - find out what type of objects they are, and see if you can scrutinize them to determine why they are not valid.

As to the duplicate, these two objects are likely either different object types, or belong to a different owner/schema.

Try

SELECT OWNER || '.' || OBJECT_NAME || ' - ' || OBJECT_TYPE FROM DBA_OBJECTS WHERE STATUS = 'INVALID'; This should give you slightly more to go on.

If they are views, they can be recreated; if such attempts fail, the views may be referencing non-existent rows in the tables they refer to.

If they are procedures, they can be recompiled. If they fail to recompile, the code for the procedures should be reviewed.

BD Received on Mon May 01 2006 - 23:24:24 CDT