DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Rollback segment

  1. #1
    Join Date
    Jan 2001
    Posts
    60
    Hi
    when i am creating rollback segments its giving a problem

    ORA-01681: Parameter unlimited_rollback_segments must be set to TRUE for this operation


    Were i need to change this parameter and so on .

    Thanks
    lnreddy
    html code is off

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Change max number of extents for the ROllback to unlimited.

  3. #3
    Join Date
    Nov 2000
    Posts
    157
    hI

    YEAH I TOO GOT THE SAME PROBLEM (because i made the maxextents unlimited)

    So i made the maxextents 121 instead unlimited then it worked fine

    Thanks
    Ravi
    ravi

  4. #4
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    in 7.3 and 8.0 (i think) you had to set the init.ora parameter unlimited_rollback_segments to true *before* you could set the maxextents for a rbs to unlimited. i don't know if you could do any alter system, but i think it required a database bounce. sorry to be a bit vague; it's been a while since i've worked in 7.3 or 8.0

    d.

  5. #5
    Join Date
    Jan 2001
    Posts
    60
    hi ravi ,
    After i changed that its doing fine for me .
    u have any idea what is the reason for that .

    Thanks for that

    Thanks
    lnr
    html code is off

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