Re: Lost Dictionary!! URGENT!!!

From: zongk Tu <jpseo_at_yahoo.com>
Date: Fri, 19 Apr 2002 00:58:38 GMT
Message-ID: <3CBE1A4F.246E785@yahoo.com>

Christine;

You have lost nothing...

You may want to re-run the follwing two scripts as SYS..

$ORACLE_HOME/rdbms/admin/utlconst.sql

$ORACLE_HOME/rdbms/admin/utlrp.sql

Then bounce the instance ..

Also, if you have JVM installed, you may want to make sure

all of your JAVA objects are RESOLVED..

HTH

--
Zongk Tu

Oracle Apps DBA/Unix SA

christine wrote:



> I accidently ran the following scripts with the list order after

> successfully install oracle 8i 8.1.7.0.0.  My dictionary is lost and

> not sure what else is missing too.  I can still login into sqlplus.

>

> 1. oracle_home\rdbms\admin\catalog.sql

> 2. oracle_home\rdbms\admin\catexp7.sql

> 3. oracle_home\rdbms\admin\catproc.sql

> 4. oracle_home\rdbms\admin\caths.sql

>

> Is there any scripts I could run to get my database back to original?

> Thank you so much if you could give me the answer!!

>

> -Christine

Received on Thu Apr 18 2002 - 19:58:38 CDT