Re: Recompiling invalid objects with a batch file

From: DA Morgan <>
Date: Tue, 04 Dec 2007 22:01:27 -0800
Message-ID: <>

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> _at_?/rdbms/admin/utlrp

or if you prefer:

UTL_RECOMP which allows you to compile in parallel or serial fashion.

or if you prefer:


No need to reinvent the wheel.

Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington (replace x with u to respond)
Puget Sound Oracle Users Group
Received on Wed Dec 05 2007 - 07:01:27 CET

Original text of this message