Re: compile invalid objects

[Tim Gorman]

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