create table gua_test( no varchar2(5));
insert into gua_test values (1);
insert into gua_test values (2);
insert into gua_test values (3);
insert into gua_test values (4);
insert into gua_test values (5);
Commit;
select count(*) from gua_test;
sysdba
----------
shu immediate
startup mount
create restore point five_rows guarantee flashback database;
odb user
---------
insert into gua_test values (6);
insert into gua_test values (7);
insert into gua_test values (8);
insert into gua_test values (9);
insert into gua_test values (10);
commit;
select count(*) from gua_test;
sysdba
----------
shu immediate
startup mount
flashback database to restore point five_rows;
alter database open resetlogs;
odb user
---------
select count(*) from gua_test;
result - 5 rows
---------------------------------------------------------------------------------------------------------------------------
odb user
---------
insert into gua_test values (6);
insert into gua_test values (7);
insert into gua_test values (8);
insert into gua_test values (9);
insert into gua_test values (10);
commit;
select count(*) from gua_test;
15
sysdba
----------
create restore point ten_rows guarantee flashback database;
odb user
---------
insert into gua_test values (11);
insert into gua_test values (12);
insert into gua_test values (13);
insert into gua_test values (14);
insert into gua_test values (15);
commit;
select count(*) from gua_test;
15
sysdba
----------
shu immediate
startup mount
flashback database to restore point ten_rows;
alter database open resetlogs;
odb user
---------
select count(*) from gua_test;
result - 10
