Oracle SQL Developer - How to Recover Dropped Table

Oracle SQL Developer - How to Recover Dropped Table

Written by
Vinish Kapoor is a seasoned software development professional and a fervent enthusiast of artificial intelligence (AI). His impressive career spans over 20 years, marked by a relentless pursuit of innovation and excellence in the field of information technology. As an Oracle ACE, Vinish has distinguished himself as a leading expert in Oracle technologies, a title awarded to individuals who have demonstrated their deep commitment, leadership, and expertise in the Oracle community.

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: