The flashback tag has no wiki summary.
2
votes
2answers
95 views
Duplicating a Database with RMAN
I would like to duplicate to the same server Oracle Database with RMAN. I've configured flash recovery area for Oracle Database. My database is using SPFILE as shown below.
SQL> SELECT ...
0
votes
1answer
40 views
How to purge logs by using Flashback feature in Oracle Database
I’ve configured flash recovery area for Oracle Database. My question is: how can I delete Flashback Database log?or is there any retention policy for that?
2- After I’ve enabled archive log mode and ...
0
votes
0answers
27 views
how to use different types of flashback
I'm very new to Flashback technology, I found on this website that, there are 3 types of flashback
Row Level
Table Level
Database Level
But, I don't know, how to enable them and use them. Please ...
0
votes
1answer
120 views
Is there a way to export Oracle's UNDO?
I tried exp utility to dump all database. Looks like this exports only the last version of data skipping undo log. Using flashback queries I see:
01466. 00000 - "unable to read data - table ...
2
votes
1answer
394 views
Flashback feature in Oracle 11g?
I am using Oracle 11gR1. As a part of a project, I have to execute multiple update statements by disabling a few constraints (triggers and check constraints) which could result in a corrupted ...
3
votes
1answer
259 views
Find out if two rows came from same transaction in Oracle
I am using Oracle 11.1 and would like to figure out if two rows in one table where inserted by the same transaction.
Is there an easy sql statement to map a row to an transactions id? The table is an ...
3
votes
2answers
320 views
Migrating to Oracle Flashback for Historization on Oracle 11g
Our application built using Oracle 11g requires that we keep historic data.
The historization is legally mandated, and is mainly used for manual queries, when investigating problems, etc. Basically ...
3
votes
4answers
322 views
Modifying table structure within a transaction?
In Oracle (and probably elsewhere), executing an ALTER TABLE statement will do an implicit commit on the current transaction.
We have a tool (written in Java) that should modify a schema by:
adding ...
1
vote
1answer
252 views
Difference between Flashback Query and Serializable Transaction Mode?
Is there any conceptual difference between a SERIALIZABLE Transaction and a Flashback Query?
11
votes
3answers
1k views
What other databases have a feature similar to Oracle's Flashback Query?
I am interested to know what other databases have features similar to Oracle's Flashback Query. It would seem that any database that supports MVCC could have the feature, but which do? SO has this ...
