Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Compile procedure in order of dependencies.

Re: Compile procedure in order of dependencies.

From: Frank <fbortel_at_nescape.net>
Date: Mon, 15 Dec 2003 22:15:22 +0100
Message-ID: <brl7of$m5j$1@news3.tilbu1.nb.home.nl>


Francesco Martelli wrote:

> [CUT]
>
>

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

>
>
> I don't find that file in the $ORACLE_HOME/rdbms/admin/ directory using
> Oracle 9i....
>
> Please forgive my prior post, it was a mistake :-S
>
> Regards, Davide
>
>

Try utlrp, not ult - Sybrand made a typo
-- 
Regards, Frank van Bortel
Received on Mon Dec 15 2003 - 15:15:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US