Recycle bin

From Oracle FAQ

Oracle maintains a recycle bin for dropped objects starting with Oracle 10g. Dropped tables go "into" the recyclebin, and can be restored (undropped) from the recyclebin.

Contents 1 Enable the database recyclebin 2 Show recyclebin contents 3 Clear recyclebin 4 Examples 5 Also see

Enable the database recyclebin

The recycle bin is enabled by default. To disable for the entire database (not recommended):

SQL> ALTER SYSTEM SET recyclebin = OFF;

To disable the recycle bin for a session:

SQL> ALTER SESSION SET recyclebin = OFF;

Show recyclebin contents

To see the objects in the recyclebin:

SHOW RECYCLEBIN

Clear recyclebin

To remove all dropped objects from the recyclebin (current user):

PURGE RECYCLEBIN;

To remove all dropped objects from the recyclebin (system wide):

PURGE DBA_RECYCLEBIN;

Tables can also be droped without sending them to the recyclebin. Example:

DROP TABLE t1 PURGE;

Examples

Drop a table:

SQL> DROP TABLE t1;

Undrop the table:

SQL> FLASHBACK TABLE t1 TO BEFORE DROP;

Also see

• Flashback - Oracle's flashback technology
• Using Oracle's recycle bin