CODEWITHSUNDEEP
oracle-databaseoracle11g
Buras
Buras

Reputation: 3099

How to recover dropped table in Oracle?

I dropped my table Departments I don't know how its happened and I can't roll it back

enter image description here

I really really need it back please help

Upvotes: 2

Views: 4177

Answers (2)

bhadra Govindarajula
bhadra Govindarajula

Reputation: 17

use FlashBack Query

flashback table departments to before drop;

Upvotes: 2

Alex
Alex

Reputation: 355

Its not a big problem you can try one of these :

flashback table departments to before drop;

or 

select * from user_recyclebin;
flashback table "BIN$...." to before drop;

Note that you can rollback DML(insert, update, delete ...) but not DDL(create, DROP...)

Good luck.

Upvotes: 10

Related Questions