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

Posted in: Technical Track

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.

About the Author

As Pythian’s Chief Executive Officer, Paul leads this center of excellence for expert, outsourced technical services for companies whose systems are directly tied to revenue growth and business success. His passion and foresight for using data and technology to drive business success has helped Pythian become a high-growth global company with over 400 employees and offices in North America, Europe, and Asia. Paul, who started his career as a data scientist, founded Pythian when he was 25 years old. In addition to driving the business, Paul is a vocal proponent of diversity in the workplace, human rights, and economic empowerment. He supports his commitment through Pythian’s hiring and retention practices, his role as board member for the Basic Income Canada Network, and as a supporter of women in technology.

No comments

Leave a Reply

Your email address will not be published. Required fields are marked *