Why we can FLASHBACK DROP table where it is DDL command and hence autocommited?
0
votes
2
answers
706
views
DROP and TRUNCATE both are DDL commands and both are autocommited.Then why we can recover DROP table by using FLASHBACK(unless it is purge) and why we can not recover TRUNCATED data(don't consider backup).
Asked by Paresh
(81 rep)
Aug 18, 2015, 05:19 AM
Last activity: Apr 7, 2025, 03:03 PM
Last activity: Apr 7, 2025, 03:03 PM