Re: Stored objects compilation

From: Ivar Stolfot <iff_at_online.ee>
Date: Wed, 29 Dec 1999 15:03:09 +0200
Message-ID: <386a06db$0$6921@diablo.uninet.ee>

Found this one in application developer guide:

All packages, procedures, and functions can be recompiled using the following syn-tax.
The objects are compiled in dependency order, enabling each to be compiled only once.
SQLPLUS> EXECUTE DBMS_UTILITY.COMPILE_ALL; Iff

Yann Chevriaux <chevriaux_at_theleme.com> wrote in message news:84cp47$fs7$1_at_wanadoo.fr...
> 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 - 07:03:09 CST