unable to extend segment

[kiru]

Hi All,

I need to update a particulare table which has more than 6000 records.
i created a script which uses 2 cursors to do the update row by row
when i excute the script i got the followin erro
DECLARE
*
ERROR at line 1:
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
ORA-06512: at "stock.OPP_UPDATE_AFTER", line 13
ORA-04088: error during execution of trigger 'stock.OPP_UPDATE_AFTER'
ORA-06512: at line 39

i coudl not figure out the problem
Please anyone who knows help me
Thanks,
Kiru

[gandolf989]

Did you create a cartesean product? How many loops are happening with the update statement? Is it possible to do the update in a single update statement rather than two nested loops?

[kiru]

I am using single update stament to update, but there are moethen one update statment for the table and also there is a update trigger as well.

When i put a loop and update row by row and commit immediately its working i but i don't want to do in that way i need to update in a signle row?
i set the undo retention =10000 still same error
ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDO'
do i need to increase the size of the undo tablespace?

[davey23uk]

your undo tablespace isnt big enough for the transaction you want to do, increase the size

[techwiz]

If 8i , you need create a large segment and assign it to this transaction.
If 9i or 10g , and you know the undo tablespace space is enough,then you need change the parameter undo_retention paramter .

[davey23uk]

If 9i or 10g , and you know the undo tablespace space is enough,then you need change the parameter undo_retention paramter .

no the undo tablespace isnt big enough - the error tells you that.

If undo retention was wrong you wuold get ORA-1555

[techwiz]

no the undo tablespace isnt big enough - the error tells you that.

If undo retention was wrong you wuold get ORA-1555

You are right

[kiru]

Yeah, You are right, I increased the Unod tablespace it worked fine