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

From: paddy_nyr <mpprpp_at_yahoo.com>
Date: Sat, 6 Mar 2004 19:36:08 -0500
Message-ID: <c2dqq8$1sh9br$1@ID-197123.news.uni-berlin.de>

"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message news:404A02DD.2BFB06BD_at_remove_spam.peasland.com...
> paddy_nyr wrote:
> >
> > "Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
> > news:4048F615.9840B35E_at_remove_spam.peasland.com...
> > > paddy_nyr wrote:
> > > >
> > > > I get the above message plus ORA-00942: table or view does not exist
> > when I
> > > > try an update a row on a table in my database.
> > > >
> > > > The table exists and I'm not sure why this is happening.
> > > >
> > > > I'm running on a Sun Solaris 8 using Oracle 8.1.7.4
> > > >
> > > > Thanks
> > >
> > > Is there a trigger on the table you are updating? If so, it could be
> > > trying to access a non-existent table.
> > >
> > > Also check to see if what you are accessing is a synonym and not a
> > > table.
> > >
> > > Thanks,
> > > Brian
> > >
> > I do a select * from table_a where col_a = 'A' and col_b = 'B' and it
> > returns a number of rows
> > Then when I try
> >
> > update table_a
> > set col_c = 'C'
> > where col_a = 'A' and col_b = 'B'
> >
> > Is when I get this message and it's happening to alot of my tables.
> >
> > I should point out that this is a new db and I imported a schema into
the
> > new db.

>

> Did you verify, as I earlier suggested, that there is no UPDATE trigger
> on this table?

>

> Cheers,
> Brian

>
Yes, there was a trigger for this table, but Oracle contacted me and said to do the following.

drop snapshot log on table_a;

After I did this it worked fine.

Thanks for the help. Received on Sat Mar 06 2004 - 18:36:08 CST