ora-1552
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: ora-1552

  1. #1
    Join Date
    Mar 2001
    Location
    south africa
    Posts
    401

    Exclamation

    Hi all,
    What do i need to fix the below issue and what's causing ..
    Pls advise. Thank you


    ora-1552 cannot use system rollback segment for non-system tablespace.

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Currently you have only SYSTEM rollback segment available. Either all other rollback segments of yours are offline or they were not created yet.

    You need to create and put online at least one more rollback segment to avoid that error.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    You need to create some more rollback segments and place them online.

    http://download-east.oracle.com/docs...21_res.htm#562

    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Jul 2002
    Location
    Lincolnshire, IL
    Posts
    203
    Create at least one rollback segment apart from system rollback segment and make it online.(Put entry in initSID.ora also)
    Sandy
    "Greatest Rewards come only with Greatest Commitments!"

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