Re: How did this happen

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)