Re: Constraining tables and ORA-04094

"MarkyG" <markg_at_mymail.tm> wrote in message news:ab87195e.0109180128.9894f7f_at_posting.google.com...
> Hi,
>
> Sorry, reposted a previous message but this time with an example.
>
> 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.
>
> Below is a sample script to experiment with.
>
> Opinions welcome ;-)
>
> Mark
>

[example snipped]

Could you check whether you have deferred constraints in one database (8.1.7) and non-deferred constraints in the other (8.0.6) Maybe the default has changed.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Tue Sep 18 2001 - 12:37:57 CDT