"versions between scn|timestamp" and "as of timestamp" actually does not need flashback database set
Hi
Oracle 19c RAC EE.
OEL 7
SQL> select flashback_on from v$database;FLASHBACK_ON ------------------NO 1 row selected.
I can successfully execute and see which rows were changed between that timeframe (within by undo_retention parameter of course).
SQL> select versions_startscn, versions_starttime, versions_endscn, versions_endtime, versions_xid, versions_operation, ...FROM tab1VERSIONS between timestamp sysdate -1/24/20 and sysdateWHERE id = 65;
Also I can query table's data at certain time (within by undo_retention parameter of course).
SQL> select * from tab1 as of timestamp sysdate -1/24 where id = 65;
I understood, that these features are available whenever I have flashback database set to ON.