Re: Lost Dictionary!! URGENT!!!

I have to agree with Daniel-- you could really (I wouldn't do it of habit) run those scripts at will and they shouldn't ever damage anything, let alone your Oracle database internal dictionary.

You might perhaps, want to do a:

select
  owner, object_name, object_type
from
  dba_objects
where
  status = 'INVALID"
order by owner, object_name, object_type;

(as system or sys)

you might have some procedures, functions, views, or other goodies that were clobbered, or subtending objects depending on their validity.

Just a suggestion; Oracle Applications would occasionally drive me nuts with that stuff.

And as an aside, writing a formal SQL script to do such a scan daily might save you much grief; I do not like invalid objects even in development.

RSH. "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 Sun Apr 21 2002 - 01:39:32 CDT