How to restore deleted table from Oracle Database

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>; >Table Dropped. 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 http://www.oracle.com/technology/deploy/availability/htdocs/Flashback_Overview.htm