Flash Back Query

What is a flash back query? This feature is also available in 9i. whats the difference between 9i and 10g (related to flash back query).

Pragati.rch
Profile Answers by Pragati.rch Questions by Pragati.rch
Feb 28th, 2008
3
2182

Questions by Pragati.rch

Database Administration

Answer

Showing Answers 1 - 3 of 3 Answers

hemant.agarwal03
Profile

Mar 12th, 2008

Oracle 10g offers significant enhancements that help insure the high availability of any Oracle database, as well as improvements in the database disaster recovery arena. This paper explores one of the most intriguing new features of Oracle 10g: Flashback Backup and Recovery. Oracle 9i provided the capability to "Flash back" to a prior view of the database via queries performed against specific logical entities. This capability was limited, of course, by the amount of UNDO data retained in the database's UNDO segments and bounded by the time frame specified by the UNDO_RETENTION initialization parameter. Oracle 10g expands these logical flashback capabilities significantly.