Re: Recompile scheme SYS (with dependences)

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 20 Sep 2001 22:54:20 +0100
Message-ID: <3BAA658C.5AD3@yahoo.com>

Victor Kolesov wrote:
>
> Hi All!
>
> We are testing following: Win 2000 + Oracle
> Application 11i + Oracle Server 8.1.6.1 .
> We don't know 'why' but many objects has been changed to status 'INVALID'
> .
>
> For OA schems we where using adadmin -> compile.
>
> Dependences in scheme SYS don't let us recompile all objects in this
> scheme.
> May be somebody already solved same problem.
> Please help us.
>
> ICQ # 54695039
> Victor Kolesov

Take a look at utlrp.sql in $ORACLE_HOME/rdbms/admin

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."

Received on Thu Sep 20 2001 - 16:54:20 CDT