Rollback problem

Hi all,

I have a problem with rollback segment. I am a beginner and do not have much knowledge of DBA.

Anyways, the problem is there is a transaction of around 105 MB. This would not fit into the normal rollbacks created and gave an error of "maxextents for rollback reached", so our DBA created a rollback of 500 MB and I used this rollback for the transaction by using the "set transaction" command. But even then the error continued. So I split the transaction by giving "commits" (and then set transaction again) in the transaction. But the error continued. The DBA then gave next extent of 50 MB and maxextents 80. But, yes, the error continued. Now I have given a commit after *every* insert and update and each transaction is less the 5 K, but the error still continues.

I don't know what else I can do and the DBA is asking me to split the transaction further. This I cannot do unless I give an insert, for say 10 columns, commit it and then update the same record for balance 10 columns. I am at a total loss. I don't think I need to split the transaction further as it is less than 5 K. Can someone please suggest what could be the problem?

Thanks and regards,
Alice Received on Thu Apr 08 2004 - 09:24:36 CDT