Tuesday, May 28, 2013

Flashback version query/Operation Column is Unknown

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

No comments:

Post a Comment