Re: Stored objects compilation

From: Alain Martinez <alain.martinez_at_steria.fr>
Date: Wed, 29 Dec 1999 12:35:35 GMT
Message-ID: <3869FFF2.9747E7CB@steria.fr>

Je ne connais pas cette commande.
Par contre tu peux te générer les commandes de compil' automatiquement : select 'alter procedure '||object_name||' compile;' from user_objects where object_type = 'PROCEDURE' and status='INVALID'; Et pareil pour les fonctions.

Yann Chevriaux a écrit :

> Hi.
> I've read in 'Oracle7 Server Release 7.3 Utilities' that some 'COMPILE ALL'
> command should exist.
> Well, I just need something like that to recompile over hundreds objects I
> got from an import.
>
> But I can't find any further doccumentation on such a command.
>
> Could any one help me?
>
> Many thanks
>
> Yann.

Received on Wed Dec 29 1999 - 06:35:35 CST