| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: compile invalid objects
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...
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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Vergara, Michael (TEM)
INET: mvergara_at_guidant.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Liststo: 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 Sat Aug 17 2002 - 13:48:19 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
 |
 |