Oracle 闪回 找回数据的实现方法

create table STUDENT
(
 idno INTEGER,
 name VARCHAR2(30),
 sex VARCHAR2(30)
)

insert into student (IDNO, NAME, SEX) values (1, '李云丽', '女');
insert into student (IDNO, NAME, SEX) values (2, '王强', ' 男 ');
insert into student (IDNO, NAME, SEX) values (3, '张伟', ' 男 ');

select object_name,original_name, type from user_recyclebin;//系统表
select * from "BIN$GWPY3LiiRD6R43mb5j3gXg==$0";//student在回收站的别名
FLASHBACK TABLE student TO BEFORE DROP;// 恢复表　

delete from student where idno='2';
commit;

CREATE TABLE QUICK_TABLE AS
SELECT * FROM student AS OF TIMESTAMP to_date( '2018-09-15 11:50' , 'yyyy-mm-dd hh24:mi' );