復制代碼 代碼如下:

ALTER SYSTEM SET recyclebin = ON;
ALTER SESSION SET recyclebin = ON;
ALTER SYSTEM SET recyclebin = OFF;
ALTER SESSION SET recyclebin = OFF;

復制代碼 代碼如下:

SELECT * FROM RECYCLEBIN;
SELECT * FROM USER_RECYCLEBIN;
SELECT * FROM DBA_RECYCLEBIN;

復制代碼 代碼如下:

FLASHBACK TABLE <<Dropped_Table_Name>> TO BEFORE DROP RENAME TO <<New_Table_Name>>;

復制代碼 代碼如下:

PURGE TABLE <<Table_NAME>>;

復制代碼 代碼如下:

PURGE INDEX <<Index_NAME>>;

復制代碼 代碼如下:

PURGE TABLESPACE<<Table_NAME>>;

復制代碼 代碼如下:

PURGE TABLESPACE<<Table_NAME>> USER <<User_Name>>;

復制代碼 代碼如下:

PURGE RECYCLEBIN;

復制代碼 代碼如下:

DROP TABLE <<Table_Name>> PURGE;

復制代碼 代碼如下:

ALTER SYSTEM SET recyclebin = ON;

復制代碼 代碼如下:

CREATE TABLE DEMO_RECYCLEBIN (COL1 NUMBER);

復制代碼 代碼如下:

INSERT INTO DEMO_RECYCLEBIN (COL1) VALUES (1); COMMIT;

復制代碼 代碼如下:

DROP TABLE DEMO_RECYCLEBIN;

復制代碼 代碼如下:

SELECT * FROM USER_RECYCLEBIN;

復制代碼 代碼如下:

FLASHBACK TABLE DEMO_RECYCLEBIN TO BEFORE DROP;

復制代碼 代碼如下:

SELECT * FROM DEMO_RECYCLEBIN;

復制代碼 代碼如下:

DROP TABLE DEMO_RECYCLEBIN PURGE;