Re: Constraining tables

markg_at_mymail.tm (MarkyG) wrote in message news:<ab87195e.0109180114.7a431983_at_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

I would start by verifying that the delete trigger identified by the error message is enabled and defined exactly the same way in both databases.

Then I would verify that any FK constraints to the target are defined the same in relation to delete restrict or cascade, and on deferrability.

That is all that comes to mind right now. Maybe someone else has another idea of what to check.

• Mark D Powell --