unable to extend segment
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: unable to extend segment

  1. #1
    Join Date
    Feb 2006
    Posts
    20

    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

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,966
    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?
    this space intentionally left blank

  3. #3
    Join Date
    Feb 2006
    Posts
    20
    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?

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    your undo tablespace isnt big enough for the transaction you want to do, increase the size

  5. #5
    Join Date
    Mar 2006
    Posts
    9
    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 .

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    Quote 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

  7. #7
    Join Date
    Mar 2006
    Posts
    9

    davey23uk, you are right

    Quote 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

  8. #8
    Join Date
    Feb 2006
    Posts
    20
    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
  •  



Click Here to Expand Forum to Full Width