select * from tab;

some tables data
.
.
.
BIN$7ek/inXeSaW2dtKYxtNoTQ==$0 TABLE (null)
BIN$aVPeQu17QxWuILhdnyTYeA==$0 TABLE (null)
BIN$enEbb7yXSIahLLFzALsg4g==$0 TABLE (null)
BIN$csvnlWvuRFKNhNQX0+Dw/w==$0 TABLE (null)

 
select object_name, original_name, type, can_undrop as "UND", can_purge as "PUR", droptime
from recyclebin;
 
 
no rows selected
 
 
select * from "BIN$7ek/inXeSaW2dtKYxtNoTQ==$0";
 
 
7839 KING PRESIDENT 17-NOV-81 5000 10
7782 CLARK MANAGER 7839 09-JUN-81 2450 10
7934 MILLER CLERK 7782 23-JAN-82 1300 10
 
 
 
 
SQL> purge table "BIN$7ek/inXeSaW2dtKYxtNoTQ==$0";
purge table "BIN$7ek/inXeSaW2dtKYxtNoTQ==$0"
*
ERROR at line 1:
ORA-38307: object not in RECYCLE BIN
 
 
-- actually this table name is emp10
 
flashback table emp10 to before drop
*
ERROR at line 1:
ORA-38305: object not in RECYCLE BIN