Hi TOM,
I am facing an issue with flashback versions query. I have described my issue below.
Query 1:
select
versions_xid XID, versions_startscn START_SCN, versions_endscn END_SCN
from employees
VERSIONS BETWEEN TIMESTAMP TO_TIMESTAMP('2021-01-01 10:00:00', 'YYYY-MM-DD HH24:MI:SS') AND
TO_TIMESTAMP('2021-06-01 10:00:00', 'YYYY-MM-DD HH24:MI:SS')
where employee_id='xyz'
the above query returns 2 records.
XID START_SCN END_SCN
0B0017008F7B0300 39280796004 39282671828 [INSERT]
2D001B0016420000 39282671828 (null) [UPDATE]
But on passing the versions_startscn value from the 1st query result in the filter condition of 2nd query,
I got 0 records returned instead of 1 record.
Query 2:
select
versions_xid XID, versions_startscn START_SCN, versions_endscn END_SCN
from employees
VERSIONS BETWEEN SCN MINVALUE AND MAXVALUE
where versions_endscn = '39282671828'
the above query returns 0 records.
Is there a way to identify the MINVALUE and MAXVALUE passed in the second query?
On what cases the MINVALUE gets set?