Re: an Oracle 8.0.5 and 8.1.5 issue

"Chris Leonard" <chris_at_databaseguy.com> wrote in message news:<sq0q8.47$xj2.65941_at_news.uswest.net>...
> You may not get a lot of replies for an 8.0.5 server, but it sounds like you
> are having trouble with mutating tables. There were some changes in how
> these were handled in Oracle8i.

The Constraining Tables Was made away with from 8.1.6 but te Mutating Table Is Still there .. But still not able to guess why a delete Triggers should Mutate.

>
> Check out your Concepts manual and your Application Developer's Guide (or
> whatever they were called in 8.0) and look up "mutating tables" in the
> index.
>
> Hope this helps,
> Chris
> ______________________________
> Chris Leonard
> MCSE, MCDBA, MCT, OCP, CIW
> The Database Guy at PPI
> http://www.propoint.com
> Brainbench MVP for Oracle Admin
> http://www.brainbench.com
>
>
> "Gunjan" <gunjansahay_at_yahoo.com> wrote in message
> news:15921bee.0204010601.19ae212b_at_posting.google.com...
> > am resending my request..got no serious solutions here the first
> > time...
> >
> > Hi all!
> > i am stuck with a strange problem. i have installed oracle8.1.5 on a
> > dummy server running on NT with a small database of 12 tables and a
> > trigger that does cascaded deletes from the child tables if the parent
> > is abt to be deleted. this works fine on the dummy server.
> > the actual server has Oracle8.0.5 and the same trigger that works on
> > 8.1.5 does not work on 8.0.5 gives Ora-04094 error saying constraining
> > tables found.
> >
> > i cannot drop the tables and recreate them, so i need to find a
> > workaround so that i dont have to recreate the tables.
> > Help me out someone!!!

Regards,
Ganesh R Received on Tue Apr 02 2002 - 00:30:52 CST