Simple example
In order to be able to flashback a table, it needs to be created with enabled row movement.
drop table fb_t purge;
create table fb_t (
a number,
b varchar2(10)
)
enable row movement;
insert into fb_t values (1, 'one');
insert into fb_t values (2, 'two');
commit;
select current_scn from v$database;
--
-- 3096729
insert into fb_t values (3, 'three');
commit;
select current_scn from v$database;
--
-- 3096735
select * from fb_t;
--
-- A B
-- ---------- ----------
-- 1 one
-- 2 two
-- 3 three
flashback table fb_t to scn 3096729;
select * from fb_t;
--
-- A B
-- ---------- ----------
-- 1 one
-- 2 two
flashback table fb_t to scn 3096735;
select * from fb_t;
--
-- A B
-- ---------- ----------
-- 1 one
-- 2 two
-- 3 three
insert into fb_t values (4, 'four');
commit;
--
-- A B
-- ---------- ----------
-- 1 one
-- 2 two
-- 4 four
flashback table fb_t to scn 3096735;
select * from fb_t;
--
-- A B
-- ---------- ----------
-- 1 one
-- 2 two
-- 3 three