Re: Rollback segment creation error ORA-01552

It's okay.
I figured it out.
I had to create a rollback segment in the SYSTEM tablespace. Then I can create my other rollback segments. "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 - 09:29:54 CET