| Share this post! | Vote this! |
|
There are a number of flashback levels
row level flashback query, flashback versions query, flashback transaction query
table level flashback table, flashback drop
database level flashback database
Oracle 10g has several error-correction techniques that use undo data, however they are only available if you use automatic undo management (AUM),
row level flashback query, flashback versions query, flashback transaction query
table level flashback table, flashback drop
database level flashback database
Oracle 10g has several error-correction techniques that use undo data, however they are only available if you use automatic undo management (AUM),
- Flashback query - retrieves data from a past point in time
- Flashback versions query - shows you different versions of data rows, plus start and end times of a particular transaction that created that row
- Flashback transaction query - lets you retrieve historical data for a given transaction and the SQL code to undo the transaction.
- Flashback table - recovers a table to its state at a past point in time, without having to perform a point in time recovery. more...
0 comments:
Post a Comment