解决办法:
先创建一个临时表,然后把远程的含CLOB字段的表导入到临时表中,再倒入本表。
create global temporary table demo_temp as select * from demo;
insert into demo_temp select * from demo@D_LINK;
insert into demo select * from demo_temp;
commit;
解决办法:
先创建一个临时表,然后把远程的含CLOB字段的表导入到临时表中,再倒入本表。
create global temporary table demo_temp as select * from demo;
insert into demo_temp select * from demo@D_LINK;
insert into demo select * from demo_temp;
commit;