Oracle Data Flashback

Suppose there is a table TEMPSQL> SELECT * from temp; id info ---------- limit 1 aaa 2 bbb 3 ccc SQL> delete from temp id = 1; 1 row deleted SQL> COMMIT; commit complete SQL> SELECT * from temp; id info ---------- restore 2 bbb 3 ccc restore Data SQL> FLASHBACK TABLE TEMP TO TIMESTAMP TO_TIMESTAMP ('2017-9-9 ', 'yyyy-mm-dd hh24: mi: ss'); ORA-08189: Unable to flash back to table SQL> ALTER TABLE TEMP ENABLE ROW MOVEMENT because ROW MOVEMENT is not enabled; table altered www.2cto.com SQL> FLASHBACK TABLE TEMP TO TIMESTAMP TO_TIMESTAMP ('2017-9-9 ', 'yyyy-mm-dd hh24: mi: ss '); SQL> SELECT * from temp; id info ---------- restore 1 aaa 2 bbb 3 ccc drop TABLE restore SQL> DROP Table TEMP; TABLE dropped SQL> SELECT * FROM TEMP; ORA-00942: no SQL> flashback table temp to before drop; SQL> SELECT * FROM TEMP; www.2cto.com ID INFO ---------- tables 1 aaa 2 bbb 3 ccc author oma1989