Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle Dabase Object INVALID

ramya3250Jan 13 2015 — edited Jan 16 2015

Hi,

We have database object which is INVALID, Can I know what job causes it got INVALID and exact time when it was INVALID. When I see DBA_OBJECTS I can only see that last_ddl_time and whenever we are applying any patches the ddl time stamp will be latest. Can I know the first occurrence of the object becomes INVALID?

and in DBA_DEPENDENCIES which column we should refer ?. In DBA_DEPENDENCEIS , I have verified all the REFERENCED_NAME which all shows VALID?

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 13 2015

Added on Jan 13 2015

#general-database-discussions

7 comments

1,456 views