Information about the objects in recycle bin:

select object_name,
original_name, type,
can_undrop , can_purge ,
droptime
from recyclebin


or

show recyclebin


Restore

flashback table mytable to before drop;


Clear recycle bin


purge recyclebin;