Oracle Flashback Drop.

When you want to recovery table from you dropped a mistake table.

sqlplus> select * from tab where tname = 'MM_200911';

no rows select

** Flashback **
sqlplus> select object_name, original_name from user_recyclebin

OBJECT_NAME ORIGINAL_NAME
------------------------------ --------------------------------
BIN$eID06aNB3xrgQFs92OZNdw==$0 MM_200911

sqlplus> FLASHBACK TABLE "BIN$eID06aNB3xrgQFs92OZNdw==$0" TO BEFORE DROP;

*** Check table again.
sqlplus> select * from tab where tname = 'MM_200911';

TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
MM_200911 TABLE

-- OR -- if you want to rename to other name.
sqlplus> FLASHBACK TABLE "BIN$eID06aNB3xrgQFs92OZNdw==$0" TO BEFORE DROP RENAME TO xxxxx;

== TaTsHuYa ==