Take the 2-minute tour ×  I am using Oracle 11gR1. As a part of
a project, I have to execute multiple update statements by
disabling a few constraints (triggers and check constraints)
which could result in a corrupted database.  If the database
gets corrupted, I have to re-import it entirely, which is an
additional task that is time consuming.  I have very little
knowledge about the Oracle Flashback feature. Will Flashback
help me to avoid these unnecessary imports? Can I set some
stable point and switch back to there if anything goes wrong?
Can someone please give me brief overview on this feature?  If
it fits my requirements, I will try to learn.  share|improve
this question You shouldn't disable the constraints in the first
place. Then you could simply rollback everything if something is
wrong –  a_horse_with_no_name Jul 6 '12 at 6:26 Can you simply
create the constraints as deferrable, defer them before you
issue the DML, and then rollback if the constraints fail to
validate at the end of the transaction