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!

invalid objects

Taj.Feb 27 2010 — edited Feb 27 2010
dear all,

i want to know is there any way to compile invalid objects. i mean.

i know there is a scrpt call "utlrp.sql" which compile invalid objects in the system.

and i want to schedule this script to be run on daily basis and if there is any invalid objects it should compile.

but my problem is i don't know how to schedule it becuase UTLRP.SQL script is on OS (rdbms/ folder) ..

my os is windows.

i hope i explain my question properly...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 27 2010
Added on Feb 27 2010
3 comments
759 views