Can I restore a table with flashback database even if I used "drop table purge"?
2
votes
1
answer
1072
views
If I issue the following statement:
drop table DontDrop purge;
It's going to be flushed out of my recycle bin so flashback statement won't work:
select * from DontDrop as of timestamp to_timestamp(sysdate-1);
Now, can I use a flashback database statement to restore it?
flashback database to timestamp (sysdate-1);
Asked by Nicolas de Fontenay
(1875 rep)
Jul 15, 2016, 03:06 PM
Last activity: Jul 18, 2016, 01:16 PM
Last activity: Jul 18, 2016, 01:16 PM