The tag has no wiki summary.

learn more… | top users | synonyms

-1
votes
1answer
49 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 ...
1
vote
1answer
83 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 ...
0
votes
0answers
40 views

How to backup the database before partitioning (RANGE) 100 GB database?

I want to carry out the partitioning activity. I am using oracle 11g R2. In case of error occurs while partitioning I might loose the data. On safer side I want to take backup of the database and if ...
1
vote
2answers
624 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 ...
2
votes
1answer
286 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 ...
2
votes
2answers
474 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
3k 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 ...
1
vote
1answer
175 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
709 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
718 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 ...
4
votes
2answers
555 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
5answers
1k 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
288 views

Difference between Flashback Query and Serializable Transaction Mode?

Is there any conceptual difference between a SERIALIZABLE Transaction and a Flashback Query?
13
votes
3answers
3k 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 ...