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
1
vote
1 answer

Use of FLASHBACK in Oracle

I have searched for the flashback command. Somewhere it is written we can rollback the truncate operation, and somewhere it is written we can't rollback. Can the FLASHBACK command in Oracle used to rollback the truncate table operation?
Yogesh Mittal
  • 187
  • 2
  • 12
1
vote
2 answers

What's the difference between Oracle Flashback Database and the Oracle (guaranteed) Restore Points?

My team is planning a very large set of updates to our apps soon, including some hefty DB updates (Oracle 11gR2). As I was writing scripts that would revert all the DB updates (as a roll back contingency) and researching potential Oracle features,…
dev_feed
  • 689
  • 2
  • 7
  • 25
1
vote
1 answer

Oracle flashback table reset

Is there a way in Oracle to check with a sql (pl/sql) statement if a table is reset by a user?
user2073471
  • 41
  • 2
1
vote
0 answers

Flashback archive is inserting data even no data changed after update statement

I have enabled Flashback archive on a table. Oracle inserts data in Flash back even if no record is changed in the table after updating a record. For example Update Dept set DEPTNO = '10' WHERE DEPTNO = '10'; When i use flashback query to extract…
Uzair
  • 11
  • 3
0
votes
1 answer

How can I retrieve the value of an attribute supported by Oracle?

Tablespace FlashBack CREATE TABLESPACE TS_Physical DATAFILE '\physical_df.dbf' SIZE 1024000 AUTOEXTEND OFF BLOCKSIZE 8192 LOGGING FORCE LOGGING ONLINE EXTENT MANAGEMENT LOCAL…
user13746660
0
votes
3 answers

Flutter TextFormField: The keyboard appeared and instantly disappeared

When I click the TextFormField, the keyboard appears, then it disappears instantly, just like blinking. I wonder that whether it is because the lacking of some parameters? Or some other problems? Thanks. Here are my relative codes. final _formKey =…
yamato
  • 85
  • 1
  • 13
0
votes
1 answer

What is going on underneath FDA queries?

Let's say I want to pull data for the TEST_TABLE table for some date. I create a query with FDA syntax: select * from TEST_TABLE as of timestamp (timestamp 2021.05.05 15:00:15); I want to check how exactly the query looks like in oracle engine.…
andrea_sottolamontagna
  • 25
  • 4
0
votes
1 answer

How to restore an earlier version of a table from recyclebin?

I'm practicing on restoring tables from recyclebin in Oralce 19. I've already known about the FLASHBACK TABLE statement. However, it does restore the last version of a table only. What if I want to restore an earlier state of my table? Here's what…
user13353974
  • 125
  • 7
0
votes
1 answer

How do I add Oracle Flashback columns to a .Net Core Entity Framework EDMX on affected entities?

During development of a .Net Core EF app, the DBAs implemented Oracle Flashback, which is queried by addressing the table being audited instead of a manual join to another table. How do I add these columns to the EDMX files so that the app may…
C. Allen
  • 35
  • 4
0
votes
1 answer

Using ORACLE Flashback with QueryDSL

We are using QueryDSL to bulk read data from an Oracle database with our SpringBoot application. final QFps fps = QFps.fps; final SQLQuery query = queryFactory.select(fps.fpId, fps.fieldA, fps.fieldB) …
Urs Beeli
  • 746
  • 1
  • 13
  • 30
0
votes
1 answer

Getting Invalid SQL syntax when using SCN and table alias

I am trying to fetch XMLType data as a String using commit SCN value as SELECT ab.userdata.getStringVal() userdata from MINER.MINERT2 ab as of scn(1558393) where ab.ID = 14; But I am getting SQL syntax error. When I use a normal query, without…
Anish Sharma
  • 495
  • 3
  • 15
0
votes
1 answer

I am having an error while I use flashback

I am having error while I try to use flashback; I am using oracle SQL I dropped the table called fixer then I want to get it back , So I use flashback , But I got an error below, Error starting at line : 52 in command - Flashback Error report…
Masum Billah
  • 133
  • 1
  • 4
  • 13
0
votes
1 answer

Oracle Undo tablespace after commit and record stored after undo_retention is crossed?

When I commit a transaction in oracle, it looks like my undo segment is released. Where does my old values go after commit? What happens to undo tablespace after we commit a transaction? And when we flashback the table, it looks like we can still…
Saman
  • 333
  • 3
  • 9
0
votes
0 answers

Oracle flashback data archive get last x records

We're using Oracle FDA for auditing, and I am trying to retrieve the last x records that a user had so I can compare them and see what change with each transaction. I've been googling around for quite some time now, and I can't quite figure out how…
cloudwalker
  • 2,346
  • 1
  • 31
  • 69
0
votes
1 answer

Flashback - Check if data ever existed in table in particular duration - Oracle

Is there a way to check if data ever exists in a table before in Oracle? Using flashback option, we can check for data like as of timestamp sysdate - x (where x is time we'd like to see data in past) But I'd like to know is there any function or…
inityk
  • 476
  • 1
  • 9
  • 18
1 2
3
4 5