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

Thread: RBS problem

  1. #1
    Join Date
    Jan 2002
    Location
    Canada
    Posts
    195

    RBS problem

    Can anyone suggest me a solution for this problem below except increase the size of RBS? I already have a 1GB for my RBS tablespace.

    install_NDX.LP_PERM
    CREATING INDEX : AV_RETURN_DETAIL_X1
    ON AV_RETURN_DETAIL (RETURN_FROM_TRANSNO,RETURN_FROM_STORE,RETURN_FROM_DATE,RETURN_FR
    OM_REG)
    *
    ERROR at line 2:
    ORA-00604: error occurred at recursive SQL level 1
    ORA-30036: unable to extend segment by 8 in undo tablespace 'RBS'

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    build the index no logging, or maybe increase the rbs space because you need it ?

  3. #3
    Join Date
    Nov 2001
    Posts
    335
    Build an index when data is not being changed. Since you can not rollback "create index " command the one does not use rollback segment at all. Build an index when there is no or min activity performed on the table you are indexing
    One, who thinks that the other one who thinks that know and does not know, does not know either!

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