Oracle Recycle Bin
Oracle 10g introduced the recycle bin. You can recover a
table that you have dropped from the Oracle recycle bin by using the
flashback table command as seen here:
SQL> DROP
TABLE books;
SQL> FLASHBACK
TABLE books TO BEFORE DROP;
The recycle bin uses the flashback table command.
However, the more time that has passed since the table was
dropped, the less likely it will be in the Oracle recycle bin (The
Oracle recycle bin is purged periodically based on a number of different
criteria).
The contents of the Oracle recycle bin can be viewed from
SQL*Plus by using the show recyclebin command:
SQL> show recyclebin;
ORIGINAL NAME RECYCLEBIN NAME
OBJECT TYPE DROP TIME
---------------- ------------------------------ ------------
------------
BOOKS
BIN$D3XWKKUCQVq2EG8/vkjNDw==$0 TABLE
2005-05-30
Purging Objects in the Oracle Recycle Bin
If you decide that you are
never going to restore an item from the recycle bin, you can use the
PURGE statement to remove the items and their associated objects from
the recycle bin and release their storage space. You need the same
privileges as if you were dropping the item.
PURGE TABLE BIN$jsleilx392mk2=293$0;
You can achieve
the same result with the following statement:
PURGE TABLE
int_admin_emp;
For more information on Oracle recycle bin, see my
notes below:
Purge
Recyclebin
