Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Constraining tables

Re: Constraining tables

From: MarkyG <markg_at_mymail.tm>
Date: 20 Sep 2001 00:55:45 -0700
Message-ID: <ab87195e.0109192355.25688c45@posting.google.com>


Thanks for all comments.
According to an Oracle Rep, there is known issue regarding this error in oracle 8 which is not published but it has been resolved in oracle 8.1.x.

Since the live system will be 8i, problem is 'kind of solved'.

Mark

mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0109180607.2cbfcaf6_at_posting.google.com>...
> 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 --
Received on Thu Sep 20 2001 - 02:55:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US