Home » RDBMS Server » Server Administration » Ora-24761 - Transaction Rolled back
icon5.gif  Ora-24761 - Transaction Rolled back [message #211529] Fri, 29 December 2006 03:56 Go to next message
Messages: 1
Registered: December 2006
Junior Member
Hi everybody,

I've got a serious problem.
I ve got an application (pro*c) who have to generate a very large transaction (over 10000 queries).
It is the transfer of over 2600 customers files(several rows of several tables each).

At the end of the transaction, there is a commit.
But the application never succeed to go to the end.
After the transfer of the first 1800 files by the transaction. An error occurs.

By following the log, the application returns the error : -24761 - Transaction Rolled back.
Its occurs randomly between the 1850 and 1950 transferred files.
So, I guessed that Oracle was running low in memory and forced a rolled back. But I've found no error of that kind in the Oracle Server log.
It seems that Oracle rolled back the transaction by himself without telling a reason.

I guess that there is a something wrong in my Oracle configuration ? What can I do to avoid this and to fix my problem?

Thanks you for your help.
And excuse my English.
Re: Ora-24761 - Transaction Rolled back [message #211533 is a reply to message #211529] Fri, 29 December 2006 04:29 Go to previous message
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Hi and welcome to orafaq

See this link
Previous Topic: could not roll back the transaction
Next Topic: How to schedule a trigger
Goto Forum:

Current Time: Sun Aug 20 18:17:27 CDT 2017

Total time taken to generate the page: 0.04882 seconds