查詢回收站：
SELECT * FROM RECYCLEBIN;
SELECT * FROM USER_RECYCLEBIN; --USER_RECYCLEBING與RECYCLEBIN是同義詞，字段完全一樣
開啟或關(guān)閉回收站：
會話級別開啟/關(guān)閉
ALTER SESSION SET RECYCLEBIN = OFF/ON;
系統(tǒng)級別開啟/關(guān)閉
ALTER SYSTEM SET RECYCLEBIN = OFF/ON SCOPE=SPFILE; (需要重啟數(shù)據(jù)庫)
查詢回收站中的表數(shù)據(jù)：
SELECT * FROM "BIN$KlM0Cy+QH0jgU3AVGujw6s==$1";
清空回收站中的數(shù)據(jù)：
PURGE TABLE EMPLOYEES; 清空回收站某張表
PURGE RECYCLEBIN; 清空回收站所有數(shù)據(jù)
PURGE RECYCLEBIN EXAMPLE USER SCOTT; 清空回收站數(shù)據(jù)，但保留scott用戶的數(shù)據(jù)
還原回收站中的數(shù)據(jù)表：
FLASHBACK TABLE EMPLOYEES TO BEFORE DROP; 還原成原來的表名
FLASHBACK TABLE EMPLOYEES TO BEFORE DROP RENAME TO EMPLOYEES_NEW; 還原成新的表名