How to restore deleted table from Oracle Database
Its new feature available in Oracle 10g database, you can restore
your deleted table from database.
Try the following command to test this.
>Drop table <Table Name>;
Oops!! Dropped the wrong table? No problem.
Just undrop it with Flashback Drop.
>FLASHBACK TABLE <Table Name> TO BEFORE DROP;
> Desc <Table Name>;
You will see dropped table description here.
How its work, to know more about this find out the
"New Features in Oracle Database 10g Release 2" section
on the following link