Re: an Oracle 8.0.5 and 8.1.5 issue

From: Chris Leonard <chris_at_databaseguy.com>
Date: Mon, 1 Apr 2002 11:03:40 -0600
Message-ID: <sq0q8.47$xj2.65941@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.

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!!!
Received on Mon Apr 01 2002 - 11:03:40 CST