@?/rdbms/admin/utlrp.sql
hth
connor
- "Vergara, Michael (TEM)" <mvergara_at_guidant.com>
wrote: > I have written scripts like this in the past,
but
> the problem
> I run into is that recompiling some objects
> invalidates others,
> sometimes in a circular loop. What I'd like to
> find/see/learn-how-to-do
> is a script that compiles things in dependency
> order. So far,
> this capability eludes me. I use Oracle 8.0.5 ->
> 8.1.7.4.
>
> Cheers,
> Mike
>
> -----Original Message-----
> Sent: Saturday, August 17, 2002 8:48 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Script "gen_recompile.sql" online at
> http://www.EvDBT.com/tools.htm...
>
> As written, it will not execute the generated
> "run_recompile.sql" script; you'll have to
> uncomment the HOST command at the bottom to do that.
> I like to leave it with it's teeth pulled however
> -- at least at first -- so I can review the
> generated script...
>
> Hope this helps...
>
> ----- Original Message -----
> To: Multiple recipients of list ORACLE-L
> <mailto:ORACLE-L_at_fatcity.com>
> Sent: Friday, August 16, 2002 4:28 PM
>
> I am feeling lazy today .. sooooo if someone can
> give me script that compiles all invalid objects
> untill all objects are valid ... will be great . Yes
> I am looking for the one which does this in a loop
> so that i dont have to run this many times to get 0
> invalid objects
>
> Thanks ,
> -Bp
>
>
Connor McDonald
http://www.oracledba.co.uk
http://www.oaktable.net
"Remember amateurs built the ark - Professionals built the Titanic"
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: =?iso-8859-1?q?Connor=20McDonald?=
INET: hamcdc_at_yahoo.co.uk
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_at_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).
Received on Mon Aug 19 2002 - 05:23:24 CDT