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> @?/rdbms/admin/utlrp
http://www.psoug.org/reference/files.html

or if you prefer:

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

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 Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org