How to Recover Dropped Table from Database

Recover dropped table in Oracle 10g using flashback

We Shall take an example as said Below

Table Name: TAB_BIJOY.

SQL> desc TAB_BIJOY;

Name Null? Type

—————————————– ——– —————————-

ID NUMBER(3)

SQL> select * from TAB_BIJOY;

ID

———-

2

2

3

4

4

5

6 rows selected.

DROP THE TABLE  “TAB_BIJOY”

SQL> drop table TAB_BIJOY;

Table dropped.

SQL> select * from TAB_BIJOY;

select * from TAB_BIJOY

*

ERROR at line 1:

ORA-00942: table or view does not exist

Oracle stores all tables in its Recycle bin once they are dropped from the database. We shall check if the above dropped table in available

SQL> select object_name,original_name from user_recyclebin;

OBJECT_NAME ORIGINAL_NAME

—————————— ——————————–

BIN$T0xRBK9YSomiRRmhwn/xPA==$0 TAB_BIJOY

SQL> flashback table TAB_BIJOY to before drop;

Flashback complete.

SQL> select * from TAB_BIJOY;

ID

———-

2

2

3

4

4

5

6 rows selected.