Error ORA-1650 in Alert File.....????? Pleaes Help
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Error ORA-1650 in Alert File.....????? Pleaes Help

  1. #1
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    I am getting the folowing error in my Alert File.

    ORA-1650: unable to extend rollback segment RB3 by 32 in tablespace RBS

    Failure to extend rollback segment 6 because of 1650 condition
    FULL status of rollback segment 6 set.
    FULL status of rollback segment 6 cleared.

    what should I do...



    [Edited by ronnie on 03-14-2002 at 04:51 PM]
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  2. #2
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    here are More Details about my Rollback segments.

    Tablespace RBS 55 MB
    Initial = 1MB
    Next 1MB

    maximun Nos of Extents = unlimited

    6 equally sized rollback segments

    Initial 256 KB
    Next = 256 KB
    Optimal: 512 KB

    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    Ur datafite for rollback segments hasn't autoexetent options.
    All space in this file done.
    Rollback segment #6 can't allocate next extent.

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