Sometimes we want to recovery committed processing. You can use two methods for this task.
Scenario : We have Countries table. This table has 5 rows. We deleted one row at this table. After we used commit. But we want to take to back.
First Method
select * from countries as of timestamp sysdate-5/1440;
This query gives countries table data five minutes ago. You can update or insert query and where statement has this query.
Second Method
alter table countries enable row movement;
flashback table countries to timestamp sysdate-5/1440;
alter table countries disable row movement;