SELECT * FROM RECYCLEBIN;

SELECT * FROM USER_RECYCLEBIN; --USER_RECYCLEBING与RECYCLEBIN是同义词，字段完全一样

ALTER SESSION SET RECYCLEBIN = OFF/ON;

ALTER SYSTEM SET RECYCLEBIN = OFF/ON SCOPE=SPFILE;--(需要重启数据库)

SELECT * FROM "BIN$KlM0Cy+QG0jgU3AVGawe9w==$0";

PURGE TABLE BIN$KlM0Cy+QG0jgU3AVGawe9w==$0;--根据OBJECT_NAME名称清除

PURGE TABLE EMPLOYEES;--根据ORIGINAL_NAME名称清除

PURGE RECYCLEBIN;--清空回收站数据

PURGE RECYCLEBIN EXAMPLE USER SCOTT;--清空回收站数据，但保留scott用户的数据

FLASHBACK TABLE EMPLOYEES TO BEFORE DROP;--还原成原来的表名

FLASHBACK TABLE EMPLOYEES TO BEFORE DROP RENAME TO EMPLOYEES_NEW;--还原成新的表名

SELECT INDEX_NAME, INDEX_TYPE, TABLE_NAME, UNIQUENESS

FROM USER_INDEXES

WHERE TABLE_NAME = 'EMP1';

ALTER INDEX "BIN$KlNYwcBGG1LgU3AVGazI7Q==$0" RENAME TO EMP_N1;