martes, 1 de marzo de 2016

FLASHBACK TABLE EXAMPLE

sql> alter user hr account unlock;
sql> alter user hr identified by hr;
sql> connect hr/hr;
sql> create table prueba as (select * from employees);
sql> select count(*) from prueba;
sql> drop table prueba;
sql> select * from prueba;
sql> flashback table prueba to before drop;
sql> create table prueba as (select * from employees);
sql> drop table prueba;
sql> show recyclebin;
sql> purge recyclebin;