Flashback Query Not Returning Correct Data After 9i To 10g Migration

Jun 6, 2005 / By Paul Vallee

Tags: ,

There is a major issue with flashback query, one of the key features of Oracle 10g. Although flashback is greatly improved in 10g (accurate within 3 seconds rather than 5 minutes in 9i), if the user actually tries to upgrade from 9i to 10g flashback query won’t work and gives wrong results. Additionally, the “transaction history” feature in 10g will be broken, giving wrong results without warning.

Leave a Reply

  • (will not be published)

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>