FLASHBACK TABLES

The basic principle of FLASHBACK :

  1. ALTER TABLE to enable row movement
  2. Do a FLASHBACK to a time that you want to recover and get your data back

Here are some examples

Testing the Flashback by dropping a table and going back in time.

— dropping a table
DROP TABLE C##floyd.TBL_ATTENDANCE_floyd;

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top