The foreign key is useful because Oracle is not committed only after each statement and the overseas key checks the integrity of the barrier.
However this suspended integrity check is very useful, sometimes I want to check integrity without executing the commitment. Is this possible in some way? (Without changing the barriers without blocking).
I am using Oracle 10G.
You can issue the all the instant set constraints if any deferred obstruction If it is violated then it will fail. You will not lose your work in case of failure: your transaction will not be brought back.