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: How did this happen

Re: How did this happen

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 02 Aug 2005 20:35:45 -0700
Message-ID: <1123040132.490542@yasure>


joe bayer wrote:
> I am assigned to a database 9206 on Window server 2003, the database seems
> working fine, but have 2000 invalid objects after re-compile. Registry is
> like this
>
> COMP_ID VERSION STATUS
> ---------- -------------------- -----------
> CATALOG 9.2.0.6.0 INVALID
> CATPROC 9.2.0.6.0 VALID
> OWM 9.2.0.1.0 VALID
> JAVAVM 9.2.0.1.0 VALID
> XML 9.2.0.2.0 VALID
> CATJAVA 9.2.0.1.0 VALID
> ORDIM 9.2.0.1.0 LOADED
> SDO 9.2.0.1.0 LOADED
> CONTEXT 9.2.0.1.0 VALID
> XDB 9.2.0.1.0 INVALID
> WK 9.2.0.1.0 VALID
> ODM 9.2.0.1.0 LOADED
> How could I fix the problem?Thanks for your help

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql

Substitute in your ORACLE_HOME for the environment variable.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Tue Aug 02 2005 - 22:35:45 CDT

Original text of this message

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