注册

归档日志内容问题

DM_515915 2025/02/26 213 3

【DM版本】: 8
【操作系统】:centos
【问题描述】*:
在下面的图片中,是通过DBMS_LOGMNR包挖掘到的归档日志内容,但是为什么有的sql_redo语句是这种格式的:INSERT INTO "TESTSYNC4"."OBJ# 3012"("COL 1", "COL 2", "COL 3", "COL 4", "COL 5", "COL 6", "COL 7", "COL 8", "COL 9", "COL 10", "COL 11") VALUES(6, '管理员_1320', 'Code_1517', '{''sysName'':''监控系统'',''srcType'':''fusionSystem''}', TIMESTAMP'2025-02-26 15:48:05', 109, TIMESTAMP'2025-02-26 15:48:07', 1349, 1, 'creator_2075', 'updater_3164'),为什么表名和字段名不是具体的名字?

而有的确实这样:INSERT INTO "TESTSYNC4"."SYS_TENANT_9"("ID", "NAME", "TENANT_CODE", "PROPS", "CREATE_TIME", "CREATOR_ID", "UPDATE_TIME", "UPDATER_ID", "VALID_FLAG", "CREATOR", "UPDATER") VALUES(6, '管理员_1320', 'Code_1517', '{''sysName'':''监控系统'',''srcType'':''fusionSystem''}', TIMESTAMP'2025-02-26 15:48:05', 109, TIMESTAMP'2025-02-26 15:48:07', 1349, 1, 'creator_2075', 'updater_3164')

image.png

回答 0
暂无回答
扫一扫
联系客服