From MGogala@oxhp.com Wed, 12 Sep 2001 14:19:03 -0700 From: "Gogala, Mladen" Date: Wed, 12 Sep 2001 14:19:03 -0700 Subject: RE: dbms_utility.compile_schema Message-ID: MIME-Version: 1.0 Content-Type: text/plain You know, of course, that 8.1.7 has a script called "utlirp.sql", residing in the usual place which compiles ALL INVALID OBJECTS IN THE DATABASE and does so in a logically consistent manner. > -----Original Message----- > From: Post, Ethan [mailto:epost@kcc.com] > Sent: Wednesday, September 12, 2001 5:15 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: dbms_utility.compile_schema > > > 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. > > > -------- Original Message -------- > > Date: Wed, 12 Sep 2001 10:55:24 -0800 > Reply-To: ORACLE-L@fatcity.com > 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 > > Confidential > 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: http://www.orafaq.com > -- > Author: Post, Ethan > INET: epost@kcc.com > > 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: ListGuru@fatcity.com (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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: MGogala@oxhp.com 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: ListGuru@fatcity.com (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).