3

Is there any conceptual difference between a SERIALIZABLE Transaction and a Flashback Query?

jcolebrand
  • 6,376
  • 4
  • 43
  • 67
Martin
  • 2,420
  • 4
  • 26
  • 35

1 Answers1

6

They are completely unrelated concepts.

  • Serializable is a type of isolation level (read here for more info)
  • Flashback Query is an Oracle technology for getting querying data as it was at a certain point in time - for example, if certain conditions are met you can use Flashback Query to get those million rows back after committing that transaction that accidentally deleted them.
Jack Douglas
  • 40,517
  • 16
  • 106
  • 178