Use Oracle's flashback table to restore Data

A colleague deleted an important Oracle table and failed to run the project! Fortunately, a DBA friend suggested that the flashback table of oracle can restore data. After using the flashback table, the results will be good and we will learn it together! Here, I would like to thank my DBA friends !!!

// Set the rows that can be moved by the outer table.

1. alter table T_DUAL enable row movement;

// Execute the restore operation for the table data from 20011 to 02-23 22:53:00

2. flashback table T_DUAL to timestamp TO_TIMESTAMP ('2017-02-23 22:53:00 ', 'yyyy-mm-dd hh24: mi: ss ');