If you take to back dropped table, you use flashback statement. The recyclebin must be on to use flashback.
Example
You use this query to see recyclebin status
show parameter recyc;
recyclebin –> onAfter
drop table employees;
flashback table employees to before drop;
Recyclebin Table
If you delete a table , This table insert recyclebin table. So this table in fact not delete. Only the table move to recyclebin table.
Example
drop table employees;
select object_name, original_name from recyclebin where original_name=’EMPLOYEES’;You can see your deleted table.