Error in creating Rollback segments in locally managed tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Error in creating Rollback segments in locally managed tablespace

  1. #1
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356

    Talking

    Hi! All
    I have ORacle8.1.7. I createad a locally managed tablespace. I want to create a rollback segment in the same tablespace.
    It is giving the following error
    SQL> CREATE PUBLIC ROLLBACK SEGMENT "largerbs"
    2 TABLESPACE "EPRORBS" ;
    CREATE PUBLIC ROLLBACK SEGMENT "largerbs"
    *
    ERROR at line 1:
    ORA-25151: Rollback Segment cannot be created in this tablespace


    Any ideas Why? It's obvious I am making a mistake, but I can't figure it out.
    There Nothing You cannot Do, The problem is HOW.

  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    guess yous tablespace is in autoallocate extent mode, no ?

  3. #3
    Join Date
    Feb 2001
    Location
    Kolkata- India
    Posts
    356
    I recreated the tablespace with uniform size 4m clause.
    After that rollbak segment creation succedeed.
    There Nothing You cannot Do, The problem is HOW.

  4. #4
    Join Date
    Mar 2001
    Posts
    65

    you need to create one rbs in system tbs before you can successfully create any rbs in a locally managed tablespace.

    i got the same error on an earlier ocasson.

    ajay

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