本文主要是介绍flashback drop实验(sys用户的除外,它没有回收站),希望对大家解决编程问题提供一定的参考价值,需要的开发者们随着小编来一起学习吧!
开启闪回: http://blog.csdn.net/rlhua/article/details/11934831
1、查询原来表的数量
sys@TEST0910> select count(*) from scott.test10;
COUNT(*)
----------
14
2、误操作drop
sys@TEST0910> drop table scott.test10;
Table dropped.
3、登陆scoot用户,查询回收站
sys@TEST0910> conn scott/tiger
Connected.
scott@TEST0910> show recyclebin
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------ -------------------
TEST10 BIN$5w/YlwePKa7gQwEAAH+tZw==$0 TABLE 2013-09-23:11:40:56
4、查询回收站里的内容
scott@TEST0910> select * from "BIN$5w/YlwePKa7gQwEAAH+tZw==$0"; ------注意:此处是双引号
EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30
7566 JONES MANAGER 7839 02-APR-81 2975 20
7654 MARTIN SALESMAN 7698 28-SEP-81 1250 1400 30
7698 BLAKE MANAGER 7839 01-MAY-81 2850 30
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7788 SCOTT ANALYST 7566 19-APR-87 3000 20
7839 KING PRESIDENT 17-NOV-81 5000 10
7844 TURNER SALESMAN 7698 08-SEP-81 1500 0 30
7876 ADAMS CLERK 7788 23-MAY-87 1100 20
7900 JAMES CLERK 7698 03-DEC-81 950 30
7902 FORD ANALYST 7566 03-DEC-81 3000 20
7934 MILLER CLERK 7782 23-JAN-82 1300 10
14 rows selected.
5、两种闪回方式
使用insert into TEST10 select * from "BIN$5w/YlwePKa7gQwEAAH+tZw==$0"; 闪回
使用flashback table闪回
scott@TEST0910> flashback table TEST10 to before drop [rename to test11];可以重命名
Flashback complete.
scott@TEST0910> select count(*) from test10;
COUNT(*)
----------
14
这篇关于flashback drop实验(sys用户的除外,它没有回收站)的文章就介绍到这儿,希望我们推荐的文章对编程师们有所帮助!