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

From: R. Schierbeek <info_at_bytelife.com>
Date: Mon, 5 Mar 2001 19:46:42 +0100
Message-ID: <pfRo6.758$PH5.2896@24hoursnet-reader-1>

Mark,

You can run catalog.sql and catproc.sql a second time - no problem. Do it as user SYS or INTERNAL though.

Cheers, Roelof

R. Schierbeek, DBA

email : info_at_bytelife.com
www   : www.bytelife.com
SQL   : www.bytelife.com/sql4dba.htm

Mark Patterson <mpatterson_at_iel.ie> schreef
> Hi,
>
> I have a database that seems to occasionally display unwarranted error
> 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 Mon Mar 05 2001 - 12:46:42 CST