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

Thread: rollback segment error

  1. #1
    Join Date
    Apr 2002
    Posts
    2
    Hi all ,
    I m trying to create a table space in new database and then after creating table space i m trying to create rollback segment but all the time i get this error

    ORA-25151: Rollback Segment cannot be created in this tablespace

    please solve my problem i m using following code to create table space and rollback segment in oracle 9i

    #set echo on
    #define ORA_HOME = "C:\Oracle\Ora90"
    #define CVC_HOME = "C:\Oracle\ORADATA\CVC"

    create tablespace CVC_RBS
    datafile '&CVC_HOME\CVC_DBS_01.DBF' SIZE 100M
    default storage ( initial 1024K
    next 1024K
    minextents 1
    maxextents 1000
    pctincrease 1);

    create rollback segment RB0
    tablespace CVC_RBS
    storage
    (
    initial 512K
    next 512K
    minextents 20
    maxextents 1000
    );

    alter rollback segment RB0 online;


  2. #2
    Join Date
    Dec 2001
    Posts
    221
    it should work fine. which platform do u use
    Santosh Jadhav
    8i OCP DBA

  3. #3
    Join Date
    Oct 2001
    Location
    Madrid, Spain
    Posts
    763
    Could you post the result of this query:

    SELECT TABLESPACE_NAME, EXTENT_MANAGEMENT, ALLOCATION_TYPE FROM DBA_TABLESPACES;


  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    in 8i you cannot create RBS in LMT without creating previously a dummy one in dictionary but I am not sure if this is true in 9i though but you may have a look into that

  5. #5
    Join Date
    Apr 2002
    Posts
    2
    Originally posted by aarroyob
    Could you post the result of this query:

    SELECT TABLESPACE_NAME, EXTENT_MANAGEMENT, ALLOCATION_TYPE FROM DBA_TABLESPACES;

    TABLESPACE_NAME EXTENT_MAN ALLOCATIO
    ------------------------------ ---------- ---------
    SYSTEM DICTIONARY USER
    UNDOTBS LOCAL SYSTEM
    CWMLITE LOCAL SYSTEM
    DRSYS LOCAL SYSTEM
    EXAMPLE LOCAL SYSTEM
    INDX LOCAL SYSTEM
    TEMP LOCAL UNIFORM
    TOOLS LOCAL SYSTEM
    USERS LOCAL SYSTEM
    CVC_DATA LOCAL SYSTEM
    CVC_INDEX LOCAL SYSTEM

    TABLESPACE_NAME EXTENT_MAN ALLOCATIO
    ------------------------------ ---------- ---------
    CVC_RBS LOCAL SYSTEM
    CVC_TEMP LOCAL SYSTEM
    CVC_USER LOCAL SYSTEM

  6. #6
    Join Date
    Oct 2000
    Location
    Charlotte, USA
    Posts
    330
    Hi see what error says..
    dbserv% oerr ora 25151
    25151, 00000, "Rollback Segment cannot be created in this tablespace"
    // *Cause: An attempt was made to create a rollback segment in a tablespace
    // with autoallocate extent allocation policy.
    // *Action: Specify a different tablespace for the rollback segment
    Thanks.
    Thanigaivasan.

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