How to Use Oracle Flashback Time Travel to Capture and Query Transactional Changes


Database & Infrastructure

Date and time






Oracle Flashback Time Travel provides the ability to capture transactional changes, to a table, over its lifetime. Flashback Time Travel provides a mechanism for tracking changes to production databases that is secure, efficient, easy to use and application transparent. Flashback Time Travel allows organizations to configure historical data capture in a matter of minutes and provides a centralized and seamlessly queryable, historical data store that can help reduce your cost of compliance. Flashback Time Travel provides many benefits over traditional application and trigger-based methods for maintaining historic data. Flashback Time Travel data is tamper-proof -- no database users, not even privileged users, can change the Flashback Time Travel maintained data. Flashback Time Travel is useful for compliance with record stage policies and audit reports and is easily queried using Oracle Flashback technologies.

Lecture details

Talk Attendence: Attendance in person
Level of difficulty: General
Desirable listeners function: Data scientist , DBA
Group of activity: Database & Infrastructure

About speaker