Constraining tables

From: MarkyG <markg_at_mymail.tm>
Date: 18 Sep 2001 02:14:22 -0700
Message-ID: <ab87195e.0109180114.7a431983@posting.google.com>

Hi,

I'm trying to delete a record from one parent table and need to remove the child records down the 'tree' structure. I have 2 identical databases table wise and with the same indexes and integrity constraints. The only difference is that one DB is version 8.1.7 (8i) and the other 8.0.6.

The delete works fine on the 8i database but on the 8.0.6 database, i get an ORA-04094: table DGNAU.TGROUPITN is constraining... error.

Question is:

Is there an init.ora parameter which makes the deletes work in one version but not the other or is it a new feature of 8i which makes the delete work.

Opinions wlecome ;-)

Mark Received on Tue Sep 18 2001 - 04:14:22 CDT