RE: batch recompile invalid packages

From: Hand, Michael T <HANDM_at_polaroid.com>
Date: Tue, 9 Jan 2001 10:20:08 -0500
Message-Id: <10736.126144@fatcity.com>

John,

Check out the alter <object_type> <object_name> compile; command. Also if you have a lot to recompile, use dynamic SQL to generate your script

Mike Hand
Polaroid Corp

-----Original Message-----
From: John Dunn [mailto:john.dunn_at_sefas.co.uk] Sent: Tuesday, January 09, 2001 7:11 AM
To: Multiple recipients of list ORACLE-L Subject: batch recompile invalid packages

Is there a easy way for me to easily recompile all my packages, functions for a user etc without doing a create/replace Received on Tue Jan 09 2001 - 09:20:08 CST