Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [flashback]

Flashback provides a way to view past states of database objects, or to return database objects to a previous state, without using traditional point-in-time recovery.

29 questions
18
votes
3 answers

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 question for SQL Server, but it seems more…
Leigh Riffel
  • 23,884
  • 17
  • 80
  • 155
5
votes
2 answers

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 insert only table. What are my options? Some…
Franz Kafka
  • 577
  • 2
  • 6
  • 16
4
votes
2 answers

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 we need to save some stuff 10 years, and we dig…
KarlP
  • 141
  • 4
4
votes
6 answers

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 some columns removing some columns updating a…
Martin
  • 2,420
  • 4
  • 26
  • 35
4
votes
1 answer

the value of undo_sql in flashback_transaction_query view is always null

so I have a table defined as follow: `create table test.test as (select * from dual); and ran the following update statements: update test.test set dummy = '1' where dummy = 'X'; commit; I want to find the undo_sql for the transaction above, so I…
hoymkot
  • 143
  • 4
3
votes
1 answer

Can you use "RENAME" instead of "FLASHBACK TABLE" to restore a table in Oracle?

Just a general question about flashback and the recycle bin in Oracle. I tried doing this on a demo oracle database I have but the recycle bin does not seem to want to be populated; and I want a quick answer. One can do the following: flashback…
Stelios
  • 389
  • 1
  • 5
  • 14
3
votes
3 answers

How to disable flashback query logging for a specific table (Oracle)?

We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it would be beneficial to have access to more…
Arturo Hernandez
  • 276
  • 2
  • 5
3
votes
2 answers

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 DECODE(value, NULL, 'PFILE', 'SPFILE') "Init File Type" FROM…
Cell-o
  • 1,106
  • 8
  • 21
  • 40
3
votes
1 answer

Difference between Flashback Query and Serializable Transaction Mode?

Is there any conceptual difference between a SERIALIZABLE Transaction and a Flashback Query?
Martin
  • 2,420
  • 4
  • 26
  • 35
3
votes
2 answers

Oracle flashback query syntax - all tables to same timestamp

I'm not finding a lot of examples online of how to use Oracle Flashback Query and I'm hoping somebody can clarify syntax. I'm trying to execute a query with a large number of tables in it, but the syntax seems to require me to specify a timestamp…
SqlRyan
  • 1,206
  • 2
  • 17
  • 24
3
votes
1 answer

How to find user who Drop any thing without auditing applied on database

In my scenario, I have a database with no flashback on, Only Archivelogs are active. No Auditing applied on database. 3 days ago some one drop all triggers, views, sequence from a specific user. Now is there any way to find out who did this? Can I…
M. AZ
  • 167
  • 3
  • 4
  • 11
3
votes
2 answers

Oracle: using "as of" clause with table aliases?

I can run this flashback query with no problem: select x from a as of timestamp sysdate; But if I use a table alias I get an error. select foo.x from a foo as of timestamp sysdate; ORA-00933: SQL command not properly ended How can I use "as of"…
Mark Harrison
  • 829
  • 5
  • 20
  • 33
2
votes
1 answer

Recover deleted oracle flashback point

I have accidentally deleted a flashback point in a oracle 11g database,Is there a way to recover the restore point PS:If I have a flashback point A which was created first, and flashback point B which was created later.If I drop flashback point B…
Nibin George
  • 33
  • 5
2
votes
1 answer

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 database. If the database gets corrupted, I have to…
madhu
  • 141
  • 1
  • 2
  • 11
2
votes
1 answer

Can I restore a table with flashback database even if I used "drop table purge"?

If I issue the following statement: drop table DontDrop purge; It's going to be flushed out of my recycle bin so flashback statement won't work: select * from DontDrop as of timestamp to_timestamp(sysdate-1); Now, can I use a flashback database…
Nicolas de Fontenay
  • 1,875
  • 2
  • 18
  • 37
1
2