Oracle数据库中闪回操作分析介绍

oracle中闪回操作分析介绍

sql> select * from student;
select * from student
              *
error at line 1:
ora-00942: table or view does not exist




sql> select * from bin$wa/yb4j1lbhguab/aqawvq==$0;
select * from bin$wa/yb4j1lbhguab/aqawvq==$0
                    *
error at line 1:
ora-00933: sql command not properly ended




sql> select * from "bin$wa/yb4j1lbhguab/aqawvq==$0";


        id name              age
---------- ---------- ----------
         1 tom                23
         2 mary               24


sql> show recyclebin;
original name    recyclebin name                object type  drop time
---------------- ------------------------------ ------------ -------------------
student          bin$wa/yb4j1lbhguab/aqawvq==$0 table        2017-09-01:01:26:38
sql> flashback table student to before drop;


flashback complete.


sql> show recyclebin;
sql> select * from student;


        id name              age
---------- ---------- ----------
         1 tom                23
         2 mary               24