Re: negative effects of running catalog.sql twice???

A very short answer is enough: no.
There is no harm done by re-running catalog.sql, as this doesn't create any dictionary tables, only views. The same applies to catproc.sql, it only recreates.
I must admit, I was unsure about this too the first time I did it.

Hth,

Sybrand Bakker, Oracle DBA

kal121_at_yahoo.com wrote in message <7gke8f$2c3$1_at_nnrp1.dejanews.com>...
>Everything was working fine up until yesterday... when I started getting an
>
>"ORA-06553: PLS-213: package STANDARD not accessible" error.
>
>The database had been running fine for several weeks prior to this, I
should
>add.
>
>So, I ran catalog and catproc again, and this appeared to have fixed the
>problem.
>
>So, my question is, are there any negative effects of running these scripts
>again? Will it blow away any old dictionary views with vital information?
>
>The installion automatically runs these scripts for me - I've never had to
>run them manually before, now I'm worried about the possible effects of
doing
>this.
>
>Thanks.
>
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon May 03 1999 - 11:36:41 CDT