Database Backup and Recovery (MOSC)

MOSC Banner

Discussions

Flashback Version Query seems to be broken in Oracle >19.6 (12.2 works)

edited Aug 27, 2020 10:44AM in Database Backup and Recovery (MOSC) 16 commentsAnswered ✓

Hello everyone,

we are using Flashback Version Querys to detect changes in a table between two given SCNs.

In 12.2 this works just fine. In 19.6 it is broken.

For example:

Consider the folowing transaction:

insert into emp3(empno) values (1);

insert into emp3(empno) values (2);

insert into emp3(empno) values (3);

insert into emp3(empno) values (4);

insert into emp3(empno) values (5);

delete from emp3 where empno = 2 or empno = 4;

commit;

In 12.2 the version query yields the folowing results:

EMPNO ROWID VERSIONS_OPERATION VERSIONS_STARTSCN VERSIONS_ENDSCN SCN_RANGE

---------- ------------------ ------------------ ----------------- --------------- -----------------------------

1 AABDg8AAHAAGBifAAA I 28451518954 NULL 28451518686 and 28451518956

3 AABDg8AAHAAGBifAAC I 28451518954 NULL 28451518686 and 28451518956

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center