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?

Comments
Post Details
Added on Oct 8 2013
7 comments
4,815 views