Re: referential integrity

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 9 Aug 2006 11:20:49 -0700
Message-ID: <1155147648.983639.38530@m79g2000cwm.googlegroups.com>

mike7..._at_gmail.com wrote:
> At what point does Oracle enforce referential integrity?
>
> For instace, if you have autocommit off and execute a series of
> statements, will it check referential integrity after each statement or
> after the "commit"?
>
> Thank you.

Depends on how the constraint was declared. If it's deferred, then on commit, else immediately as the statement is executed. But not "after" in any case.

I wonder if you are doing some exam preparation? ;)

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Wed Aug 09 2006 - 13:20:49 CDT