Re: Lost Dictionary!! URGENT!!!

From: RKG <rkg100_at_erols.com>
Date: Thu, 18 Apr 2002 18:59:50 -0300
Message-ID: <a9nj67$ag4$1@bob.news.rcn.net>

you didnt lose them... since they have already been run the script did not complete... you dropped the synonyms. Login as SYS and then do a connect internal; your views will be there.

I was getting the 904 error when I tried to export and Metalink said to run those scripts :( Id guess you ran into something similiar.

I did that last week and I dont remember what my DBA did to fix it..... Im sure someone here can help you.

"christine" <chris_yehbien_at_hotmail.com> wrote in message news:2d3df43b.0204181248.6cd42403_at_posting.google.com...
> 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 - 16:59:50 CDT