OraFAQ Forum: General

Home » Other » General » Need Help (oracle10g on linux)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need Help [message #279748]

Sat, 10 November 2007 02:00

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.

Report message to a moderator

Re: Need Help [message #279757 is a reply to message #279748]

Sat, 10 November 2007 03:13

Littlefoot
Messages: 21807
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.

Report message to a moderator

Previous Topic:	TWO-TASK SERVER: error = 12571
Next Topic:	database 10g home page

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 14:26:28 CDT 2024