Skip to Main Content

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Nov 7 2013
Added on Oct 8 2013
7 comments
4,967 views