when i use this hint , i am able to select clob columns from a remote db.
something like
select /*+ driving site(d)*/ * from table_clob
cross join
dual d
But when i use the very same query to populate the select result to my local table , i get ora-22992.
something like
insert into local_table
select /*+ driving site(d)*/ * from table_clob
cross join
dual d
This fails in the case of CTAS too.
Any way to populate my local tables?