Re: Running catalog.sql and catproc.sql a second time

Running sql.bsq a second time created a duplicate set of users in dba_users (2 SYS, 2 SYSTEM, 2 OUTLN, etc.) and
also returns 2 results when obviously expecting only 1 on certain selects.

Dave.

    (Oracle 8.1.5 on Solaris 2.7 with an ambiguous manual mention of who should run sql.bsq.....)

Mark Patterson <mpatterson_at_iel.ie> wrote in message news:3A9F9088.C586E303_at_iel.ie...
> Hi,
>
> I have a database that seems to occasionally display unwarranted error
> messages.
> For instance - our application will receive an "ORA-00942 table or view
> does not exist" error message when the table in question does in fact
> exist and the user has the correct privileges.
>
> This only occurs very infrequently, and most often the same statement
> works fine. It probably only fails on about one in a hundred executions.
>
> After exhaustively examining the database (fruitlessly!) I'm beginning
> to think there may be a corruption or error in the system views and/or
> tables. I would like to recreate these if possible.
>
> Is it possible to run catalog.sql and catproc.sql a second time without
> damaging the existing schema and stored procedures or can theses scripts
> only be run at database creation?
>
> Thanks,
> Mark.
>
Received on Tue Mar 06 2001 - 07:02:32 CST