DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    I get this:
    POSPROD.RTNYC.COM:posprod> @test_pos_admin_pkg
    ORA-02067: transaction or savepoint rollback required

    ERROR at line 1:
    ORA-02055: distributed update operation failed; rollback required
    ORA-00920: invalid relational operator
    ORA-02063: preceding line from POSPROD
    ORA-02063: preceding 2 lines from POS_TO_QA
    ORA-06512: at "POSPROD.POS_ADMIN_PKG", line 359
    ORA-06512: at line 9

    error -1 still updates the business table (where id = ID)
    Error accessing package DBMS_APPLICATION_INFO
    ORA-02067: transaction or savepoint rollback required
    I am simply doing an update inside a package across a DB link. I am doing it to several databases. We are in the process of upgrading from to Only 1 DB is upgraded so far, and I get this error now against it.

    I did remake the DB link, and restarted the listener. No help.

    any ideas?

  2. #2
    Join Date
    May 2000
    For a distributed transaction,
    - Disable table level lock
    - Create public rollback segments

  3. #3
    There are public RBS... how do I disable table locks across the link?

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.