79928

Retrieving a Dropped Table

This section assumes that you created and then dropped the reg_hist table. as described in "Dropping a Table" on page 9-36. The following procedurę retrieves

reg_

hist from the recycle bin.

To perform the Flashback Drop operation:

1. Connect SQL*Plus to the hr schema and obtain the namc 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

2. Rctricvc 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;