DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Ora-02064: Distributed Operation Not Supported

  1. #1
    Join Date
    Nov 2005
    Location
    Brazil
    Posts
    22

    Ora-02064: Distributed Operation Not Supported

    I have the FUNCTION in database A, it writes in tables at database A. It is work.
    But I need to use this FUNCTION in database B, then I have created de
    SYNONYM for this FUNCTION, but when I execute, I am getting the following error message:
    ORA-02064: distributed operation not supported
    What do I do ?

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,492

    Cool



    Maybe the reason for this is that the FUNCTION in database (A) is trying to do a commit.

    Instead the source database (B) should control this commit.

    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width