Skip to Main Content

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!

Determine when objects become invalid

CasimirApr 9 2008 — edited Apr 9 2008
Hello

I regularly have invalid objects in several instances. I created a job that is scheduled every day to recompile all invalid objects in an instance.

But it's always try and error when deciding at which time to run the job. Unfortunately, I do not have enough application know-how to point out the cause, so I just solve the problem (that is done quick and comfortable with this workaround)

Is there a way to determine when objects become invalid?

Thanks for your responses Casi
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 7 2008
Added on Apr 9 2008
5 comments
2,245 views