Oracle Database Discussions

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!

insert into postgresql from oracle 11g using database link

DanielHPOct 8 2013 — edited Oct 10 2013

hey all,

a got a problem when i try to insert into postgre table

copy from sa/sa@xe insert "ora"."tab0"@orapos3 using select * from tabel0;

SP2-0498: missing parenthetical column list or USING keyword

at "ora"."tab0"@orapos3, data type of all of column are text

at tabel0 data taype of all of column are varchar2..

is this the cause?

This post has been answered by DanielHP on Oct 10 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Nov 7 2013

Added on Oct 8 2013

#heterogeneous-connectivity, #insert

7 comments

6,300 views