Skip to Main Content
Forums

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!

ORA-02064 - distributed operation not supported

user5716448Sep 12 2016 — edited Sep 12 2016

Hi,

Using oracle 10.2.0.4 and have statement below

MERGE INTO table@remote_dbase a

          USING (SELECT product_num             

                  , supplier_num

                 from products p

                 where p.prod_num = 777777

          )b

          ON (a.prod_num = b.prod_num)

                      WHEN MATCHED

                         THEN UPDATE                          

                             SET a.supplier_num = b.supplier_num

                            

                             but get message

ORA-02064 - distributed opeartion not supported.

Why is this?

Is there a way to do a merge  to a remote database using a database link?

Thanks
This post has been answered by Saubhik Banerjee on Sep 12 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 10 2016
Added on Sep 12 2016
2 comments
526 views