Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Mailing Lists -> Oracle-L -> RE: dbms_utility.compile_schema

RE: dbms_utility.compile_schema

From: Post, Ethan <>
Date: Wed, 12 Sep 2001 13:13:47 -0700
Message-ID: <>

Excellent solution Charlie! - E

-----Original Message-----
Sent: Wednesday, September 12, 2001 1:25 PM To: Multiple recipients of list ORACLE-L

When there are mutiple INVALID objects it can be the case that object Z uses object Y which uses object X. If X, Y & Z are invalid, you'd need to invoke dbms_utility.compile_schema up to THREE times if the invalid objects are compiled in alphabetical order.

My PL/SQL procedure use an invalid object counter and remains in a WHILE LOOP until the current invalid object count equals the previous loop's invalid
object count. Once two consecutive dbms_utility.compile_schema results in the same number of invalid objects, then you can exit out of the loop and exit the procedure.

Date:    Wed, 12 Sep 2001 10:55:24 -0800        
Organization:    Fat City Network Services, San Diego, California       
To:      Multiple recipients of list ORACLE-L <>    

Package bodies, procedures, function in packages need to be compiled before packages. DBMS_UTILITY.compile_schemaI believe compiles in Alphabetically order not in functional order. Kathy

-----Original Message-----
<> ]
Sent: Wednesday, September 12, 2001 10:11 AM To: Multiple recipients of list ORACLE-L  

Is there something wrong with dbms_utility.compile_schema . When I tried to use it , I left with few invalid objects . But if I manually compile those objects using alter package *** . they get compiled .Any Idea why ? BIgP

This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited.

This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you.


Please see the official ORACLE-L FAQ:

Author: Post, Ethan
Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message to: (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Wed Sep 12 2001 - 15:13:47 CDT

Original text of this message