Tophe wrote:Undo use read consistency,recover, image of data before changing.In your case need more undo space
I have an OWB Mapping (which translates into a MERGE query) that often fails with the above error. I wanted to have more information on UNDO. What uses most UNDO?
Aman.... wrote:You are right :-), i was confused there.you have to increase undo_retention initialization parameter.Why to increase when there is already a space related error coming? Either OP should decrease it or increase teh size of the datafile of the tablespace, isn't it ?