Re: Recompiling invalid objects with a batch file

Ubiquitous wrote:
> Is there a way to write a sqlplus batch file to "recompile all invalid
> objects", or at least compile a specific object? I know the capacity 
> exists in TOAD but I have no idea what's going on behind the scenes...
> 
> Thanks!

No reason to make it difficult on yourself:

SQL> @[EMAIL PROTECTED]
 if you prefer:

UTL_RECOMP
http://www.psoug.org/reference/utl_recomp.html
which allows you to compile in parallel or serial fa****on.

or if you prefer:

DBMS_UTILITY.COMPILE_SCHEMA
http://www.psoug.org/reference/dbms_utility.html

No need to reinvent the wheel.
-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Wa****ngton
damorgan@[EMAIL PROTECTED]
 (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org