oracle to tidb OGG 配置lower-case-table-names = 1 参数后无法区分大小写

ogg:12.3版本 tidb:v3.0.5

在tidb创建的表名为小写

报错如下:

2020-04-30T10:43:59.871+0800 WARNING OGG-00769 Oracle GoldenGate Delivery for MySQL, rep.prm: Failed to validate table name (TEXT) in Database (ODB). SQL error (0). 2020-04-30T10:43:59.951+0800 ERROR OGG-00868 Oracle GoldenGate Delivery for MySQL, rep.prm: Query to retrieve Octect Length Failed for database=‘rodb’ AND table=‘TEXT’ AND column=2. 2020-04-30T10:43:59.951+0800 ERROR OGG-01668 Oracle GoldenGate Delivery for MySQL, rep.prm: PROCESS ABENDING.

ogg 复制进程配置

REPLICAT REP TARGETDB xx@xxx:4000, USERID xxx, PASSWORD xxx SQLEXEC “set tidb_constraint_check_in_place=1” HANDLECOLLISIONS DISCARDFILE ./dirrpt/rep.dsc, PURGE MAP xx., TARGET xx.;

±-----------------------±------+ | Variable_name | Value | ±-----------------------±------+

| lower_case_file_system | 1 |

| lower_case_table_names | 1 |

±-----------------------±------+

2 rows in set (0.01 sec)

按我的测试需要把表名改成大写才能同步,请问这种情况是否有办法处理呢?

看看这个帖子是否有帮助,多谢