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!

distributed operation not supported

455790Jul 17 2006 — edited Jul 17 2006

All i want to merge some data from a remote database into my local database when i run the following code i get this error

ORA-02064: distributed operation not supported

merge into exlinkcopy lct
USING ( SELECT trader,lastlogindate, lastlogintime
	 from trader@remotehost ) exl
ON (lct.trader = exl.trader)
WHEN MATCHED THEN
 update set lct.lastlogindate = exl.lastlogindate , lct.lastlogintime = exl.lastlogintime

I thought database links where supported in oracle 10

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 14 2006

Added on Jul 17 2006

18 comments

1,480 views