This content has been marked as final. Show 8 replies
this error for insufficient undo segments,
you need to increase the size of undo.
unable to extend segment by string in undo tablespace 'string'
Cause: the specified undo tablespace has no more space available.
Action: Add more space to the undo tablespace before retrying the operation. An alternative is to wait until active transactions to commit.
Edited by: CKPT on Aug 30, 2010 1:34 PM
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?
Edited by: Chinar on Aug 30, 2010 1:16 AM
not neccessary to increase undo size,,i hope u u r aware that undo tablespace is cyclic method ..may be if some operations hold the undo table spaces..
please wait for some time and check the alert log if any ora-errors coming..if the tablespace not increasing automatically then only we can increase the tablespace..
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 ?
@ Tophe refer Troubleshooting ORA-30036 - Unable To Extend Undo Tablespace [ID 460481.1]
One little, tiny correction that i want to make. I can get what you wanted to say when you said "increase the tablespace". Normally we are not increasing the size of the tablespace, we are increasing the size of the "datafiles" in that tablespace. That is tricky and how words can change everything i know but just for the information :)
I think the OP's undo tablespace size is 100% full and the auto extensible ability is disabled. He needs to either increase the size of the datafile in the undo tablespace slightly more or enable the auto extensible of one more datafiles (if exists) to a particular new and more bigger size.