Sample Header Ad - 728x90

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