How to view dml in logmnr?
Oracle Database 19.3 Enterprise edition
SELECT OPERATION, STATUS, SQL_REDO FROM V$LOGMNR_CONTENTS WHERE USERNAME = 'MYUSER';
I see my ddl: create table test (tcol number);
But I do NOT see my dml: insert into test values(123);
Supplemental logging is turned on:
SELECT SUPPLEMENTAL_LOG_DATA_MIN FROM V$DATABASE;
YES