ogg不支持只含有clob列的表的同步,(参考:Can GoldenGate Replicate An Oracle Table That Contains Only CLOB Column(s)? (文档 ID 971833.1)),于是尝试了一下HVR:
创建测试表:
create table test_clob( name clob);
然后配置好action,load:
看来,HVR也是不支持的。
其实,这应该是意料之中的,因为:
To make those columns available to GoldenGate, they must be logged to the Redo Log by Oracle's Supplemental Logging feature.
Oracle does not support Supplemental Logging for CLOB columns;
therefore Updates and Deletes on those columns cannot be replicated by GoldenGate.
对于HVR也是一样的,对于oracle来说,HVR的复制也是基于联机和/或redo日志的,既然oracle不支持clob写日志,那么自然不能同步只含有clob列的表。