2007/09/10

What Do All 10g Flashback Features Rely on and what are their Limitations?

There's a great MetaLink article on Flashback - check it out!

What Do All 10g Flashback Features Rely on and what are their Limitations?
Doc ID: Note:435998.1
  • What Do All Flashback Features Rely on ?
  • Differences Between New Oracle 10g Flashback Technologies
  • Limitations of Flashback Database
  • Limitations and Restrictions on Flashback Drop
  • Limitations and Restrictions on Flashback Tables
Here are two gems that were news to me:
  • To be able to flashback a table, you must enable row movement for the table
  • Because DML operations are used to bring the table back to its former state, the ROWIDs in the table change. As a result, Flashback Table is not a viable option for applications that depend on the table’s ROWIDs to remain constant
Note that altering a table to enable row movement will cause underlying PL/SQL to become invalid!!!

No comments: