Recover dropped tables in Oracle with Plsql by mistake

First, view the table in the Recycle Bin

Select Object_name,original_name,partition_name,type,ts_name,createtime,droptime from RecycleBin;

Second, the recovery table

Sql>flashback table Test_drop to before drop; Sql>flashback table "Bin$b+xkko1rs5k10uko9bfmua==$0" to before drop;

Note: This method must require that the Oracle version must be 9i or 10g or higher, and flashback cannot recover the full-text index

See also: http://althars.iteye.com/blog/216164

Recover dropped tables in Oracle with Plsql by mistake