SQL & PL/SQL

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!

How to find invalid objects(procedures,functions,...) and recompile them?

greddyAug 7 2006 — edited Aug 8 2006

Hi

I want to find out all invalid objects(procedure,functions and triggers) and recompile them if i find any.

how to do that?

any idea?

Thanks
Reddy

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 5 2006

Added on Aug 7 2006

13 comments

2,059 views