想同步oracle外部表到内部表,SIGNATURE_IMAGE字段是blob

Viewed 34

想同步oracle外部表到内部表,SIGNATURE_IMAGE字段是blob,目前查询报错,各位大佬们,目前有办法同步吗?
create table test_sink as select id,SIGNATURE_IMAGE from oracle_catalog.TEST.test_source

Error Failed to execute sql: java.sql.SQLException: (conn=2600) errCode = 2, detailMessage = Unsupported type 'UNSUPPORTED_TYPE' in 'SIGNATURE_IMAGE'.

1 Answers

目前还不支持 oracle blob 数据类型,咱们 blob 中存的是什么呀,是二进制还是string呢?