gotchaMinor
Difference between Flashback Query and Serializable Transaction Mode?
Viewed 0 times
querymodeserializabledifferencebetweentransactionandflashback
Problem
Is there any conceptual difference between a
SERIALIZABLE Transaction and a Flashback Query?Solution
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.
Context
StackExchange Database Administrators Q#2711, answer score: 6
Revisions (0)
No revisions yet.