@?/rdbms/admin/utlrp.sql hth connor
--- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]> > 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: [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).
