From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Flashback Query requirements

Flashback Query requirements - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Flashback Query requirements

“

- [Instructor] Oracle Flashback is a set of technologies built right into the Oracle database, with provides us with our very own personal database time machine. Using Flashback, we can revert changes which have been applied to our entire database or parts of it using a single command. In order for Oracle Flashback technologies to function, there are some prerequisites we need to first take care of. Different Oracle Flashback features require different prerequisites. For Flashback query, which allows us to perform and run queries that retrieve previous data from our tables, all within the SQL statement itself. So for Flashback query, we need to properly configure our Oracle database undo retention parameter. This is because Flashback query relies on the undo table space for it to function. The undo retention parameter controls how much time should Oracle hold on to undo data. The bigger the value for the parameter, the longer the time Oracle holds on to your undo data before…

Contents