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!

insert data into remote table using dblink

ArvindcbgAug 21 2017 — edited Aug 22 2017

Hello Guys,

I am using Oracle 8174 as local database (on windows2000 server) and 11g (on windows 2003 server) as remote database.

I want to insert data into remote table using DBLINK as follows :-

insert into remote_data@link11g (SELECT name,add,desgn,city,mob_no FROM local_DATA WHERE city like 'ABC')

/

it returns errorĀ  ---

ERROR at line 1:

ORA-03113: end-of-file on communication channel

It works when insert data from 10g to 11g or 12c.

Any solution.

Thanks

Arvind

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 19 2017
Added on Aug 21 2017
13 comments
4,717 views