How to Restore Some Data or a Whole Table on Oracle?
- February 11, 2020
Accidentally dropping a table can be a career ending action is if you made in production environment.
The best ways is to use the FLASHBACK TABLE statement to restore an earlier state of a table in the event of human or application error. The time in the past to which the table can be flashed back is dependent on the amount of undo data in the system. Also, Oracle Database cannot restore a table to an earlier state across any DDL operations that change the structure of the table.