-
unable to extend segment
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
-
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?
-
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?
-
your undo tablespace isnt big enough for the transaction you want to do, increase the size
-
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 .
-
Originally Posted by techwiz
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
-
davey23uk, you are right
Originally Posted by davey23uk
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
-
Yeah, You are right, I increased the Unod tablespace it worked fine
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|