Re: Compile procedure in order of dependencies.

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Mon, 15 Dec 2003 17:34:50 -0800
Message-ID: <XitDb.19883$BQ5.78@fed1read03>

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

Read The Fine Manual at
http://tahiti.oracle.com Received on Mon Dec 15 2003 - 19:34:50 CST