Re: Rollback segment creation error ORA-01552

From: Robert Malikian <robertmalikian_at_hotmail.com>
Date: Sun, 6 Jan 2002 05:06:53 -0800
Message-ID: <3c37dab5$1_at_news1.homechoice.co.uk>


  1. Can you check to see if your system rollback segment is online?
  2. Create a new rollback segment in system tablespace and give it a srb01, make sure it is online then issue your command. Robert "Joe Moore" <japlha_at_sympatico.ca> wrote in message news:UQHZ7.39828$AS4.4837855_at_news20.bellglobal.com...
    > I have been trying to create a database manually.
    > I can create the database but it doesn't have any tablespaces other than
    > SYSTEM.
    >
    > I can create the tablespace.
    > I created two tablespaces called ROLLBACK, USER_DATA and one temporary
    > tablespace called TEMP.
    >
    > When I try to create a rollback segment in the ROLLBACK tablespace I get
    the
    > following error:
    > ORA-01552 cannot use system rollback segment for non-system tablespace
    > 'ROLLBACK'
    >
    > Here is my create rollback segment statement:
    > create rollback segment rbs01 tablespace rollback
    > storage(initial 100K next 100K minextents 20 maxextents 100 optimal 5M);
    >
    > It seems like I'm in a catch-22 here. I need to create a non-system
    rollback
    > segment in order to create a non-system rollback segment.
    >
    > I've tried putting the statement rollback_segments =(rbs01, rbs01) in my
    > init.ora file but I get an error when opening the database since these
    > rollback segments don't exist.
    >
    > What am I missing?
    >
    > Thanks
    > Joe
    >
    >
    >
    >
Received on Sun Jan 06 2002 - 14:06:53 CET

Original text of this message