ORA-00604 Errors -- 7.1.6

From: Trey Breckenridge <trey_at_ERC.MsState.Edu>
Date: 1995/06/27
Message-ID: <3spl02$ct1_at_NNTP.MsState.Edu>#1/1

After upgrading from 7.0.16 to 7.1.6, I am consistently getting "ORA-00604: error occurred at recursive SQL level 1" errors. I first noticed the problem when trying to export data (see below). I have tried reruning the catalog.sql and catproc.sql scripts, but noticed the same error occurring in the "_at_standard" section of the catproc.sql script. Thinking that this could be due to a cursor limitation, I doubled the open_cursors parameter with no success. On another note, this error seems to prevent the catproc.sql script from completing successfully, consequently disabling PL/SQL (or at least part of it).

Here is the error while trying an export:

   About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting snapshots
. exporting snapshot logs
. exporting job queues

   EXP-00008: ORACLE error 604 encountered
   ORA-00604: error occurred at recursive SQL level 1
   ORA-00904: invalid column name
   EXP-00222: 

   System error message 2
   EXP-00000: Export terminated unsuccessfully

Does anyone have any ideas on this?? Please help!

-- 
    Trey Breckenridge               Mississippi State University/NSF
     -Systems Administrator           ENGINEERING RESEARCH CENTER
     -Database Administrator                     for
    trey_at_ERC.MsState.Edu             Computational Field Simulation

Received on Tue Jun 27 1995 - 00:00:00 CEST