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)
按我的测试需要把表名改成大写才能同步,请问这种情况是否有办法处理呢?