Stack Overflow
Stack Overflow

Questions tagged [flashback]

*Flashback* is an Oracle technology that enables users to view previous states of the database.

Oracle Flashback is a group of database technologies and commands that lets users and database administrators view / restore previous states of the database. It is used mostly after data was erroneously deleted / updated, and the changes were committed before the error was noticed.

See Oracle documentation for Flashback

61 questions
2
votes
1 answer

Oracle: how to flash back a specific column?

How do I flash back a specific column for all rows in a table? For example, given this table: select * from t as of scn 1201789714628; a b - - x 1 y 2 z 3 select * from t; a b - - x 4 y 5 z 6 I can flash back a column in a specific row as…
Mark Harrison
  • 297,451
  • 125
  • 333
  • 465
2
votes
1 answer

Flashback versions query

The select statement returns two rows id || description 1 TWO 2 TWO I am kind of expecting three rows id || description 1 ONE 1 TWO 2 TWO according to the statement from the link which reads It returns all…
HalfWebDev
  • 7,022
  • 12
  • 65
  • 103
2
votes
2 answers

Oracle flashbacks, query for past data

Did you know how exactly query for past data works? The version of oracle is 10G With this query I can recover some data, but sometimes this query select * from table as of timestamp systimestamp - 1 retrieve an error (too old snapshot). Is…
Vargan
  • 1,277
  • 1
  • 11
  • 35
1
vote
1 answer

How do I properly use Oracle Flashback to audit table changes with user information?

My organization has chosen to use Oracle Flashback to replace manually created audit tables. However, the DBA set the TUNED_AUTORETENTION values and UNDO_RETENTION to only 14400 seconds. Unfortunately, we have to keep the audit values for 7 years…
C. Allen
  • 35
  • 4
1
vote
1 answer

How do I exclude unchanged fields in Flashback query resultset?

Is it possible to exclude unchanged fields in Flashback query resultset? Consider I have following table create table first_table ( id int generated as identity, name NVARCHAR2(1024), age smallint, notebook nclob, userpic clob, …
expert
  • 29,290
  • 30
  • 110
  • 214
1
vote
0 answers

Oracle Flashback Archive and ORA-08181: specified number is not a valid system change number

Hi I created Oracle flashback Archive with retention of 1 month and enabled this archive on few of the tables. But when i execute a versions query like below, i get Error "ORA-08181: specified number is not a valid system change number. ORA-06512:…
mediocre_10
  • 61
  • 2
1
vote
1 answer

error sql at level 1 insufficient privilage oracle

SQL> flashback table ticket to timestamp TO_TIMESTAMP('13-11-2018 22:30:56', 'dd-mm-yyyy hh24:mi:ss'); flashback table ticket to timestamp TO_TIMESTAMP('13-11-2018 22:30:56', * …
seanmc
  • 31
  • 2
1
vote
1 answer

Do enabling flashback slows down updates/inserts in oracle?

I have two doubts around oracle flashback queries: Is the flashback feature enabled by default in Oracle? Because in a few of my tables I see null values in versions_startscn and others version columns. Does flashback slows down inserts/updates in…
Bikas Katwal
  • 1,895
  • 1
  • 21
  • 42
1
vote
0 answers

Disable Oracle recycle bin for specific users

To keep aligned with organizational policies and developmental framework and also keep the Database storage & space management clean, I want to disable Oracle Recycle Bin for non-DBA users. Is there a way to disable recycle bin for specific users,…
shubhammakharia
  • 147
  • 1
  • 2
  • 10
1
vote
1 answer

Oracle Flashback on System Tables

Is there a possibility to use the Oracle Flashback on System tables, such as the user_tables or cols? I was able to successfully issue Flashback queries against the tables I created, but when I tried the same against System tables, I get ORA-01031:…
Sampath
  • 1,144
  • 1
  • 21
  • 38
1
vote
0 answers

From where is my Java code executing?

I've got a generic Java problem baked into a specific roadblock. I am attempting to set up Flashback on my Win10 box, but am hitting this stack trace on the command ./startAdminServer.sh -port 1234 --stacktrace java.lang.IllegalArgumentException:…
Matt
  • 1,674
  • 2
  • 16
  • 34
1
vote
0 answers

How to use a flashback query to get deleted rows?

I am trying to test a stored procedure which is deleting data from a table and have a setup similar to this: Oracle Setup: CREATE TABLE table_name ( id NUMBER ); PL/SQL Script: DECLARE v_scn V$DATABASE.CURRENT_SCN%TYPE; v_row…
MT0
  • 143,790
  • 11
  • 59
  • 117
1
vote
1 answer

Oracle Flashback Data Archive Version Query With Join?

I have a situation in where I am trying to essentially get a list of all changes that have occurred on a dataset between two points in time. This seems like a very good case for the VERSIONS BETWEEN keyword in Oracle, but I do not know how to…
user2345171
  • 11
  • 3
1
vote
0 answers

Does Hibernate 2nd level cache use just the WHERE clause or the entire query to construct the cache?

Scenario: I have a product table with a primary key of product ID. I have set up hibernate with a secondary cache (ehcache) with a read-only strategy and query caching has been enabled. I have a request to start using Oracle's flashback…
Khush
  • 853
  • 2
  • 8
  • 21
1
vote
2 answers

SELECT AS OF a version before column drop

1/ Does FLASHBACK and SELECT AS OF/ VERSION BETWEEN use the same source of history to fall back to ? This question is related to the second question. 2/ I am aware that FLASHBACK cannot go back before a DDL change. My question is for SELECT AS OF,…
Kenny
  • 1,902
  • 6
  • 32
  • 61
1
2
3 4 5