in

Oracle SQL Developer - How to Recover Dropped Table

In Oracle SQL Developer, recover a dropped table by using the Recycle Bin option.

Recover Dropped Table Using Oracle SQL Developer

Follow these steps in Oracle SQL Developer to recover a dropped table from Oracle Database.

  1. Open Oracle SQL Developer and connect to the database.
  2. Then expand the connection node in the left side panel.
  3. You will see the list of object types. Then scroll down and locate the Recycle Bin option to recover a dropped table, as shown in the below image:

SQL Developer - Recycle Bin

  1. Expand the Recycle Bin node.
  2. There you will find the list of the tables dropped previously in Oracle database.
  3. Right click on a table you want to restore, then choose the option Flashback to Before Drop. The following window will display:

Flashback table in Oracle SQL Developer.

  1. Give a new name for the table you are recovering, for example, emp_restored. Then click on the Apply button to restore the table, and you will get the message that the flashback complete, as shown in the below image:

Table recovered.

The dropped table EMP has been recovered, you can check it by running the select statement, as shown in the below example:

SELECT
     *
 FROM
     emp_restored;

See also:

Written by Vinish Kapoor

An Oracle Apex Consultant, Oracle ACE, and founder of foxinfotech.org and orclqa.com a question and answer forum for developers.

guest

0 Comments
Inline Feedbacks
View all comments