合 OGG-05798 Write LOB Column Segment Operation (token 0x23) Detected At Trail File (Doc ID 2843936.1)
现象
我用ogg21.3同步Oracle 12c到MySQL 8.0时,同步blob对象报错:
ERROR OGG-05798 Write LOB column segment operation (token 0x23) detected at trail file /oggoracle/dirdat/eo000000000, RBA 2759, for table LHR.IMAGE_LOB, column T_IMAGE. Write LOB column segment operation is not supported for this target.
解决
在源端添加如下参数,然后重新抽取:
1 | TRANLOGOPTIONS FETCHPARTIALLOB |