Am trying to view the database to see the transaction that has taken place in the database. but whenever i query the flashback_transaction_query, it returns 'no rows selected' pls, is there something i need to do that am not doing, i need your help. below is the sql statement i ran to view the table.
SQL> ed
Wrote file afiedt.buf
1 select name, course, id, versions_operation,versions_starttime as starttime, versions_xid from dept
2 versions between timestamp
3 to_timestamp('13-nov-2020 02:58:45', 'dd-mon-yyyy hh24:mi:ss')
4* and to_timestamp('13-nov-2020 03:09:07', 'dd-mon-yyyy hh24:mi:ss')
SQL> /
NAME COURSE ID V STARTTIME VERSIONS_XID
---------- ---------- ---------- - --------------------------------------------------------------------------- ----------------
Stephen Mech Eng 5 U 13-NOV-20 03.00.56 AM 0200010015050000
Moses Chem101 2 D 13-NOV-20 02.59.57 AM 03000F00DD040000
Moses Chem101 2
Belle chem101 3
Moniq Mech Eng 5
Serah Phy201 2 I 13-NOV-20 03.03.20 AM 0700150038040000
Ian Phy101 1 I 13-NOV-20 03.03.20 AM 0700150038040000
Ehiedu micro203 4
Loveth Med 6
9 rows selected.
SQL> ed
Wrote file afiedt.buf
1 select xid, start_scn,logon_user, table_name, undo_sql from flashback_transaction_query
2* where xid=hextoraw('0200010015050000')
SQL> /
no rows selected
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.SQL> select xid, start_scn,logon_user, table_name, undo_sql from flashback_transaction_query
2 where xid=hextoraw('0200010015050000');
no rows selected
SQL> select * from dba_flashback_txn_report;
no rows selected
am using ORACLE 12cR2 on oracle linux operating system. Thank you.