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.
Interested in working with Paul? Schedule a tech call.