Any idea if this one works on Oracle 8? Sounds like compile_schema compiles
the entire schema regardless of status (TRUE|FALSE)? Also a bug in 8.0.4
prevents it from working. I would like to incorporate this functionality in
a utlities package I am building and want it to work on all versions > 8.0.
Thanks,
Ethan Post
>-----Original Message-----
>From: Gogala, Mladen [mailto:[EMAIL PROTECTED]]
>Sent: Wednesday, September 12, 2001 3:27 PM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: dbms_utility.compile_schema
>
>
>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:[EMAIL PROTECTED]]
>> 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: [EMAIL PROTECTED]
>> Organization: Fat City Network Services, San Diego,
>> California
>> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>>
>> 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-----
>> <mailto:[EMAIL PROTECTED]> ]
>> 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: [EMAIL PROTECTED]
>>
>> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
>
>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: [EMAIL PROTECTED] (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).
>
------------------------------------------------------------------------------
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
