Re: Compiling Procedures and Dependencies

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 13 May 2004 23:38:41 GMT
Message-ID: <5GToc.66924$oL4.28233@newssvr25.news.prodigy.com>

Sybrand Bakker wrote:

> On Thu, 13 May 2004 09:56:28 -0400, "paddy_nyr" <mpprpp_at_yahoo.com>
> wrote:
>
>

>>I'm using Oracle 8.1.7.4 and is there a way to compile a procedure and it's
>>dependencies in one statement?
>>
>>Thanks
>>

> There is no need for it. Dependent procedures will be marked invalid,
> and automagically be recompiled when invoked.
>
> If you want to recompile all invalid procedures use the utl_rp.sql
> script in $ORACLE_HOME/rdbms/admin, connected as SYS
>
>
> --
> Sybrand Bakker, Senior Oracle DBA

Another alternative is

exec DBMS_UTILITY.COMPILE_SCHEMA (user);

which is limited to just one schema and doesn't require SYSDBA privilege.

--Mark Bole Received on Thu May 13 2004 - 18:38:41 CDT