Re: How did this happen

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1123040132.490542_at_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)

"SQL> @$ORACLE_HOME/..." ? How archaic.

The following format is preferred:

SQL> @?/rdbms/admin/utlrp.sql

"?" will resolve to $ORACLE_HOME.

-- 

Andreas Sheriff
Oracle 9i Certified Professional
Oracle 10g Certified Professional
Oracle 9i Certified PL/SQL Developer
----
"If you don't eat your meat, you cannot have any pudding.
"How can you have any pudding, if you don't eat your meat?"

DO NOT REPLY TO THIS EMAIL
Reply only to the group.