1. Resume before we decide we want to return to the point in time,,
SELECT *
FROM the TEST AS OF TIMESTAMP TO_TIMESTAMP (' 2018-03-07 15:33:00 ', '- DD YYYY - MM HH24: MI: SS');
2. The following table data recovery,
FLASHBACK TABLE TEST TO TIMESTAMP TO_TIMESTAMP (' 15:33:00 2018-03-07 ', '- DD YYYY - MM HH24: MI: SS');
Can see an error, the reason is that there is no open line,
3. Open the table line move,
The ALTER TABLE TEST ENABLE ROW MOVEMENT;
4. Perform data recovery again,
FLASHBACK TABLE TEST TO TIMESTAMP TO_TIMESTAMP (' 15:33:00 2018-03-07 ', '- DD YYYY - MM HH24: MI: SS');
Then look at the data, you can see has been restored,