Re: Compile procedure in order of dependencies.

[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 Received on Mon Dec 15 2003 - 04:03:44 CST