解决办法： 
   先创建一个临时表，然后把远程的含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;