Toad World® Forums

Recompiling All Oracle Invalid Objects.


#1

This is a very simple request for help.
I know there is a script to recompile all invalid objects in Oracle.

Oracle 11g
linux

Looked under --/RDMS/------ but cannot find it.
This would be one Oracle provided.

Anybody know the name?
Appreciate the help.


#2

ignore my prior reply!

I think you are looking for %ORACLE_HOME%/rdbms/admin/utlrp.sql


#3

YES.
Thank you.
Appreciate the help.