RE: compile invalid objects

[Vergara, Michael (TEM)]

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----- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Saturday, August 17, 2002 8:48 AM To: Multiple recipients of list ORACLE-L Subject: Re: compile invalid objects 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 ----- From: BigP To: Multiple recipients of list ORACLE-L Sent: Friday, August 16, 2002 4:28 PM Subject: compile invalid objects 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