Hi
We are kind of new to Oracle database and do have some questions on the Oracle flashback feature.
We use Oracle 11g R2 (Standard Edition ONE), Oracle 12c R1 (Standard Edition TWO).
We wanted to use the flashback option anytime a user accidentally drops a table or deletes any rows
in a table. We will not be using the flashback for entire database restore.
1) Does Oracle Flashback work in all editions of the database ( standard edition ONE, standard edition TWO, EE) ?
2) Should the database be in Archivelog mode to use the flashback feature ?
3) Is their any difference in Flashback feature in 11g Vs 12c ?
Any other suggestions are appreciated.