2022 Developer Survey is open! Take survey.

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
33 views

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 ...
user avatar
  • 215
-1 votes
2 answers
53 views

Flash Area Full - Actions

I have seen some recommendations in the Oracle Docs about what to do if the FRA is full. For example I have this config also: CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE'; ...
user avatar
0 votes
1 answer
806 views

Oracle Can a Dropped View Be Recovered?

I dropped a view 20 minutes ago. Can I recover it? If yes, how?
user avatar
0 votes
1 answer
124 views

Using AS OF TIMESTAMP or DBMS_FLASHBACK.ENABLE_AT_TIME across multiple schemas [closed]

We have a requirement to read data as of certain time (say T1) from, say, schema 1, fill some staging tables in schema 2 with that data. And then read data from some other tables of schema 1 as of T1 ...
user avatar
  • 11
2 votes
1 answer
127 views

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 ...
user avatar
1 vote
2 answers
2k views

Finding extents of Oracle BIN$ segments

I am looking for information on recyclebin extents. When dropping a table its segments are renamed to 'BIN$...' system generated names and the extents are hidden. Will those extents still stop me ...
user avatar
  • 1,408
3 votes
2 answers
5k views

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 ...
user avatar
  • 1,218
3 votes
1 answer
12k views

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 ...
user avatar
  • 167
2 votes
1 answer
760 views

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(...
user avatar
1 vote
1 answer
2k views

Oracle how to manage the flashback log space? [closed]

I set db_flashback_retention_target=1440min,Why the flashback log kept 7 days? Thanks! closed as unclear what you're asking by Phil, Michael Green, Tom V, Shanky, Andriy M Jan 5 at 12:53 Why the sql-...
user avatar
2 votes
2 answers
1k views

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 ...
user avatar
2 votes
0 answers
306 views

Keeping version history / Slowly changing dimension

We're creating a new version of a 20 years old database, in which we used to keep version history by creating new rows in each table (SCD Type 2). SCD Type 2 is not that hard when you need to keep ...
user avatar
  • 123
0 votes
1 answer
115 views

Oracle 11.2 restore DB to a specific point

I should execute following tasks: 1. test system and during test change Oracle data and Create New/Remove Old datafiles and tablespace. 2. at the end of test rollback to behviour before of point 1. I'...
user avatar
  • 33
3 votes
1 answer
1k views

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 ...
user avatar
  • 339
1 vote
1 answer
303 views

Extract from Oracle at given time

I have a requirement to retrieve (extract) data from an Oracle database (either 9i or 10g) as at a given point in time. I will need access to the data at this point of time for several days ...
user avatar
0 votes
1 answer
170 views

quick checkpoints for development mode

i'm a programmer, not a dba. i need a mechanism to quickly make a snapshot of a database (oracle 11g XE) before i run migration. migration changes data, grants, DDL (tables, triggers, lexers, views ...
user avatar
  • 109
1 vote
1 answer
110 views

Emulating Oracle flashback functionality [closed]

I'm considering going from Oracle Enterprise Edition (EE) to SE/SE1 but want to retain the flashback database and flashback table features from EE. Does anyone know how to emulate these features in ...
user avatar
3 votes
3 answers
2k views

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 ...
user avatar
4 votes
1 answer
2k views

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 ...
user avatar
  • 143
3 votes
2 answers
863 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 DECODE(...
user avatar
  • 1,048
0 votes
1 answer
20k 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 ...
user avatar
  • 1,048
1 vote
1 answer
302 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 ...
user avatar
2 votes
1 answer
1k 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 database....
user avatar
  • 141
5 votes
2 answers
2k 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 ...
user avatar
4 votes
2 answers
1k 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 ...
user avatar
  • 141
4 votes
6 answers
5k 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 ...
user avatar
  • 2,391
3 votes
1 answer
363 views

Difference between Flashback Query and Serializable Transaction Mode?

Is there any conceptual difference between a SERIALIZABLE Transaction and a Flashback Query?
user avatar
  • 2,391
18 votes
3 answers
12k 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 ...
user avatar
  • 23.5k