Flashback in 10g

Flashback in 10 g is really easy.

Suppose you drop a table by mistake. This creates a BIN$ table in the recyclebin which you can not select from the BIN$

SQL> select * from tab;
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
BIN$04LhcpndanfgMAAAAAANPw==$0 TABLE

To get it back simply type:

SQL> FLASHBACK TABLE RECYCLETEST TO BEFORE DROP;


For more info:
http://www.oracle.com/technology/pub/articles/10gdba/week5_10gdba.html

Interstingly:
plsql developer does not show the bin$ tables in the tree list panel but sqlnavigator does.