Data recovery method of oracle drop table of table

 
-- View the database recycle bin  
select object_name,original_name,partition_name,type,ts_name,createtime,droptime from recyclebin; 
-- Recovery   
FLASHBACK TABLE  Table name  TO BEFORE DROP; 

This can restore the table structure and the data is also restored
Must be supported by 9i or 10g, flashback cannot recover full-text index