Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

driving site hint

Oracle ManiacSep 24 2013 — edited Sep 24 2013

     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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 22 2013
Added on Sep 24 2013
2 comments
605 views