Re: Deferring Referential Constraints
Date: 25 May 1994 10:36:56 -0600
Message-ID: <2rvur8$h2u_at_tibalt.supernet.ab.ca>
Mike Dwyer (miked_at_pss5.ftc.scs.ag.gov) wrote:
> We are currently an Informix shop (using Version 5.0-SE), but rumors suggest
> that Oracle may become our platform of choice in the not-too-distant future.
> We have been looking at adding referential constraints to our database,
> but have discovered that the SE version of Informix does not allow those
> constraints to be deferred during a transaction. (Other Informix engines
> do allow deferral until commit.)
> My question is whether Oracle does, and beginning at what version.
> Please respond to the group or to:
> miked_at_ftc.scs.ag.gov
> Thanks,
> Mike Dwyer
According to my docs & experience, you can't defer 'directly'. However, if you are using Pro*C (the precompiler) or OCI (the API), you can selectively turn constraints on & off.
/Hans Received on Wed May 25 1994 - 18:36:56 CEST