Restore point creation

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