Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Compile procedure in order of dependencies.
$ORACLE_HOME/rdbms/admin/utlrcmp.sql.
HTH
tED
"Francesco Martelli" <mortecerta_NOSPAM__at_libero.it> wrote in message
news:4GfDb.212888$hV.8271912_at_news2.tin.it...
> [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 - 19:16:15 CST