Checking integrity of pending foreign keys in Oracle

Question

Deferred foreign keys are useful because Oracle checks the integrity of the foreign key constraint only on commit, and not after each statement.

Although this delayed integrity check is very useful, sometimes I want to check the integrity without committing. Is it possible somehow? (Without changing emergency restrictions).

I am using Oracle 10g.

Answer 1

you can issue set constraints all immediate. It will not work if any deferred constraint is violated. In case of failure, you will not lose your job: your transaction will not be canceled.