unable to extend segment
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
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
Click Here to Expand Forum to Full Width