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.