This section assumes that you created and then dropped the reg_hist table, as described in "Dropping a Table." The following procedure retrieves reg_hist from the recycle bin.
To perform the Flashback Drop operation:
Connect SQL*Plus to the hr schema and obtain the name of the dropped table in the recycle bin.
SHOW RECYCLEBIN;
ORIGINAL NAME RECYCLEBIN NAME OBJECT TYPE DROP TIME
-------------- ------------------------------ ------------ -----------
REG_HIST BIN$ANbliLHaSiu02xI+zbvDvQ==$0 TABLE 2012-03-26:16:51:54
Retrieve the dropped table using the FLASHBACK TABLE … TO BEFORE DROP command.
The following command performs a flashback of the HR.REG_HIST table.
FLASHBACK TABLE HR.REG_HIST TO BEFORE DROP;
Note:
When a table is retrieved from the recycle bin, all the dependent objects for the table that are in the recycle bin are retrieved with it. They cannot be retrieved separately.
If the retrieved table had referential constraints before it was placed in the recycle bin, then re-create them.
This step must be performed manually because the recycle bin does not preserve referential constraints on a table.