v$logmnr_contents,operation_code=3, sql_redo, set column values are null
----------------------------------有问题-------------------------------------------
begin
DBMS_LOGMNR.ADD_LOGFILE('+ARCH/DB/ARCHIVELOG/2023_07_10/thread_1_seq_6594.1436.1141835991');
dbms_logmnr.start_logmnr(startscn => 4492344025,options =>dbms_logmnr.dict_from_online_catalog + DBMS_LOGMNR.PRINT_PRETTY_SQL);
end;
select scn,sql_redo,operation from v$logmnr_contents q where rownum<2 and table_name ='test'
scn[4492344025]
operation[UPDATE]
sql_redo[update "ts"."test"
set
"UUID" = NULL,
"TRAN_DT" = NULL,
"EXT1" = NULL,
"EXT2" = NULL,
"EXT3" = NULL,
"EXT4" = NULL,
"EXT5" = NULL,
"EXT6" = NULL,
"EXT7" = NULL,
"EXT8" = NULL,
"EXT9" = NULL
where
"UUID" = '35fcce91108142169e8f01c33f439fe1' and
"TRAN_DT" = '20230710' and
"EXT1" = '163826' and