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>
Date: Sun, 6 Jan 2002 05:06:53 -0800
Message-ID: <3c37dab5$1_at_news1.homechoice.co.uk>
- Can you check to see if your system rollback segment is online?
- 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
>
>
>
>