Re: error while running catalog.sql and catproc.sql

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Wed, 21 Nov 2001 18:58:32 +1100
Message-ID: <3bfb5e1f$0$13482$afc38c87@news.optusnet.com.au>

You were logged in as SYS to run both?

Hope so.
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Sunil Pant" <spant_at_eline.com> wrote in message
news:o3EK7.4729$Le.114018_at_sea-read.news.verio.net...


> I recently upgraded to Oracle 8.1.7 Enterprise from 8.15 in solaris 8.

When


> I ran catalog.sql I encountered several

> messages like this:

> ORA-00604: error occurred at recursive SQL level 1

> ORA-00904: invalid column name

>

> While running catproc.sql I encounted several messages like this:

>

> ORA-06554: package DBMS_STANDARD must be created before using PL/SQL

>

> What went wrong.  Any suggestions would be appreciated.

> Thanks,

> SP

>

>

Received on Wed Nov 21 2001 - 01:58:32 CST