Home » Other » General » Need Help (oracle10g on linux)
Need Help [message #279748] Sat, 10 November 2007 02:00 Go to next message
mohseni
Messages: 3
Registered: November 2007
Location: india
Junior Member

Hi,
I've a procedure which delete rows from my primary table(on db1) and insert them into another table in another DB(say db2,using database link).
I call this procedure in infinite looop but in some cases i get the following errors.
ORA-02055: distributed update operation failed; rollback required
ORA-02067: transaction or savepoint rollback required

Can anyone help me to find out why I'm getting this error ?
and is there any better strategy(solution) for my need? my need is deleting 500 record per each second.

Thanks.

Re: Need Help [message #279757 is a reply to message #279748] Sat, 10 November 2007 03:13 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This is what Oracle says; see if it can help:
Quote:

ORA-02055: distributed update operation failed; rollback required

Cause: a failure during distributed update operation may not have rolled back all effects of the operation. Since some sites may be inconsistent, the transaction must roll back to a savepoint or entirely

Action: rollback to a savepoint or rollback transaction and resubmit

Quote:

ORA-02067: transaction or savepoint rollback required

Cause: A failure (typically a trigger or stored procedure with multiple remote updates) occurred such that the all-or-nothing execution of a previous Oracle call cannot be guaranteed.

Action: rollback to a previous savepoint or rollback the transaction and resubmit.
Previous Topic: TWO-TASK SERVER: error = 12571
Next Topic: database 10g home page
Goto Forum:
  


Current Time: Sat Dec 03 22:02:02 CST 2016

Total time taken to generate the page: 0.09838 seconds