Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Why V$LOGMNR_CONTENTS SQL_REDO statements become to contain "HEXTOROW()" but previously shown as normal string/number

Leiq DolphinMar 25 2024

Hi All,

I recently turn on Supplemental logging for a table for CDC purpose, and I can see the operations logged through V$LOGMNR_CONTENTS, however I found the SQL_UNDO and SQL_REDO at the beginning shown properly like:
INSERT into CDC_TEST.SOURCE_TABLE (COL1,COL2,COL3,COL4) values('d4','23upd','c4','a')

but after some while when query it again, the SQL_UNDO and SQL_REDO will become to contain “HEXTORAW('XXXX')” like below:
INSERT into CDC_TEST.SOURCE_TABLE (COL1,COL2,COL3,COL4) values (HEXTOROW('6434'),(HEXTOROW('c1150b'),(HEXTOROW('6334'),(HEXTOROW('6112'))

Any reason why it changed like this?

Comments
Post Details
Added on Mar 25 2024
0 comments
41 views