Discussions
Flashback Version Query seems to be broken in Oracle >19.6 (12.2 works)
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