求助ORACLE 11G 不开闪回能不能使用回收站?
环境是11G,用的用户是SYSTEM,回收站属性是ON,没开闪回。把测试表删了以后回收站里看不到。也恢复不了。。。。求问怎么回事?
SQL> show user
User is "system"
SQL> show parameters recyclebin;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
recyclebin string on
SQL> create table SCOTT.EMP_DEPT as select * from SCOTT.EMP;
Table created
SQL> SELECT * FROM SCOTT.EMP_DEPT;
EMPNO ENAME HIREDATE SAL COMM
----- ---------- ----------- --------- ---------
1 zhangdawei 2017/1/6 1000.79 0.03
1 zhangdawei 2017/1/9 1000.79 0.08
SQL> DROP TABLE SCOTT.EMP_DEPT;
Table dropped
SQL> SELECT * FROM SCOTT.EMP_DEPT;
SELECT * FROM SCOTT.EMP_DEPT
ORA-00942: 表或视图不存在
SQL> SELECT * FROM RECYCLEBIN;
OBJECT_NAME ORIGINAL_NAME OPERATION TYPE TS_NAME CREATETIME DROPTIME DROPSCN PARTITION_NAME CAN_UNDROP CAN_PURGE RELATED BASE_OBJECT PURGE_OBJECT SPACE
------------------------------ -------------------------------- --------- ------------------------- ------------------------------ ------------------- ------------------- ---------- -------------------------------- ---------- --------- ---------- ----------- ------------ ----------
SQL>