Re: Compile procedure in order of dependencies.

From: Frank <fbortel_at_nescape.net>
Date: Mon, 15 Dec 2003 22:13:07 +0100
Message-ID: <brl7k9$8l8$1@news4.tilbu1.nb.home.nl>

Francesco Martelli wrote:

> [CUT]
>
> Thank you all to the fast answer you gave me!
>
>

>>>dbms_utility.compile_schema('<schemaname>')
>>>to compile all invalid objects use $ORACLE_HOME/rdbms/admin/ultrp.sql
>>>connected as internal

>
>
> I can use it across a query placed into an external application? Or I have
> to do a Stored Procedure that perform to me that operation??
>
>

>>utl_recomp.recomp_serial can also be used to compile schema's and is
>>a lot faster than dbms_utility.compile_schema, or so it seems

>
>
> Where I find the documentation about it???
>
> Regards, Davide
>
>

This is something Normally Not Needed... I would hesitate to code this into an application Documentation: in the script, probably. Or do a describe utl_recomp.

-- 
Regards, Frank van Bortel

Received on Mon Dec 15 2003 - 15:13:07 CST