HiveBrain v1.2.0
Get Started
← Back to all entries
gotchaMinor

Difference between Flashback Query and Serializable Transaction Mode?

Submitted by: @import:stackexchange-dba··
0
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.