CTAS a CLOB table over a DBLink
Hello Experts,
Can you please tell me as to how I can CTAS or build a materialized view at a locla site refering to a table with CLOBs in a remote site.
create materialized view V_Local as Select * from T_clobtable@remote site;
Desc T_clobtable@remotesite;
col1 CLOB
col2 CLOB
name varchar2()
Regards,
Valli