rollback segment error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: rollback segment error

  1. #1
    Join Date
    Jun 2003
    Posts
    108

    rollback segment error

    Hi All,

    Can anyone help me in this issue.

    I got the following error when i run a big process.

    ORA-01562: failed to extend rollback segment number 11
    ORA-01628: max # extents (121) reached for rollback segment RB10.

    can i increase the data file size on rollback segment table space.

    Please help me.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    it says maxextents...

  3. #3
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    I would create a LARGE rollback segment and prior to running the
    large transaction ... set the transaction to use the large rbs instead
    of extending the smaller rollback segment to death ...

    sql> set transaction use rollback segment large_rollback_segment_name

    Otherwise ... as Pando says ... Set the maxextents for the rollback
    segments to unlimited (if you can't set the rollback segment as
    shown above ... you'll get whatever one Oracle will give you)

    HTH
    Gregg

  4. #4
    Join Date
    Jan 2001
    Posts
    3,131
    How bout adding a COMMIT?

    Call me kooky but this seems simplest.

    MH
    I remember when this place was cool.

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