SQL > SELECT START_SCN,OPERATION,LOGON_USER,XID FROM FLASHBACK_TRANSACTION_QUERY WHERE TABLE_NAME=’TEST’;
The Output will be like this :
XID TABLE_OWNER TABLE_NAME OPERATION LOGON_USER UNDO_SQL
—————- ———– ———- ——————————– ———- —————
0600090064030000 TX UNKNOWN TEST
0600090064030000 TX UNKNOWN TEST
To avoid Unknown Status enable supplemental logging by
SQL> ALTER DATABASE ADD SUPPLEMENTAL LOG DATA ;
Database altered.
Thank you
Osama mustafa
Technology Geek 