Re: Compiling Procedures and Dependencies

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Fri, 14 May 2004 22:19:30 +0200
Message-ID: <c839e5$16f$1@news2.tilbu1.nb.home.nl>

Mark Bole wrote:

> 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
>

Make that: DBMS_UTILITY.COMPILE_SCHEMA (user, FALSE); It will not invallidate all object, only compile, thus it is faster. Default is TRUE...

-- 

Regards,
Frank van Bortel

Received on Fri May 14 2004 - 15:19:30 CDT