ORA-01552: Cannot use System Rollback For non-system tablespace
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: ORA-01552: Cannot use System Rollback For non-system tablespace

  1. #1
    Join Date
    Jun 2001
    Posts
    243

    ORA-01552: Cannot use System Rollback For non-system tablespace

    I'm getting following error when user tries to insert.

    ORA-01552: Cannot use System Rollback For non-system tablespace

    I created UNDO Tablespaces and I checked my RBS and there is only SYSTEM RBS. Is this right or do I need to create another RBS? I thought UNDO TS supposed to take care all this in 9i?

  2. #2
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    In init pramaeters u nned to specify

    undo_management=AUTO
    undo_tablespace=UNDO_TBS_Name

    and i think u need to bounce ur DB for changes to be effective


    abhay.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  3. #3
    Join Date
    Jun 2001
    Posts
    243
    I have those set in my init.ora

  4. #4
    Join Date
    Aug 2002
    Location
    Bangalore, India
    Posts
    405
    Just see the output of the following query and see whether you get non system rollback segments listed.

    select * from v$rollname;
    -nagarjuna

  5. #5
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by gaegoori
    I have those set in my init.ora
    U said u created UNDO TBS right....

    then i suppose u need to bounce DB, for changes to be effective.

    Abhay
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  6. #6
    Join Date
    Feb 2001
    Posts
    295
    If you have just one undo tablespace it's not necessary to specify it, Oracle can automatically find the first one available and use it.

    Just assure that UNDO_MANAGEMENT is set to AUTO.
    An ounce of action is worth a ton of theory.
    —Friedrich Engels

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