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!

Shell script to validate all invalid objects?

571299Apr 28 2009 — edited Apr 29 2009

Hello DBA's.

New to DBA ing and so seek your help.. I am using oracle Oracle9i Release on a Solaris box.

I need a shell script that will check all invalid objects on a DB and would validate it by running utlrp.sql. I know i can do this manually but i am asked to automate the process..

Kindly suggest where i can find a shell script or share this script with me.. it would be much appreciated.

Regards!

Locked Post

New comments cannot be posted to this locked post.

Locked on May 26 2009

Added on Apr 28 2009

3 comments

1,519 views