How to recover a dropped table in oracle database?

In order to restore a dropped table, first you have to configure your database to support flashback database i.e. Configure flashback database. Once the flashback database is enabled run the following SQL code:

FLASHBACK TABLE SCHEMA.TABLENAME TO BEFORE DROP;

Here is the sample script to restore a dropped table:

SQL> conn mereba/mereba@to_primary
Connected.
SQL> flashback table techtest to before drop;
 Flashback complete.
 SQL> select * from techtest;
         ID NAME
---------- ------------------------------
         1 mereba Tech

 ID NAME
---------- ------------------------------
         1 mereba Tech
 SQL>

[/apcode]