Deferring Referential Constraints

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 Received on Tue May 24 1994 - 18:33:11 CEST