Re: Cannot use system rollback segment error during install of Oracle 8.1.7ee on Windows 2000 Advanced server

You have only one rollback segment, SYSTEM. This is a special rollback segment which is being used to rollback DDL. You can't use it for ordinary transactions, as the error states.
To resolve the problem
create rollback segment rb_temp
storage (initial 1m next 1m minextents 4) tablespace system;

alter rollback segment rb_temp online;

Hth,

Sybrand Bakker, Oracle DBA

"Terry Adams" <tadams111_at_hotmail.com> wrote in message news:rezg6.77$Zg4.58941_at_newsr1.u-net.net...
> Hello,
> I wonder if anyone knows about this...
> During installation of Oracle version 8.1.7ee on Windows 2000 Advanced
> server with no service packs installed when it was in the 'Adding Oracle
> intermedia' phase of a database creation I received the following error
> notification:
>
> Oracle 01552 Cannot use system rollback segment for non-system table space
> DRSYS
>
> This happened when the progress bar was at 97% of database creation.
> Selecting the ignore button does not dismiss the error notification. When
 I
> clicked OK I was notified that Oracle database configuration assistant
> failed. Any suggestions on what I should do next would be welcome and has
> anyone out there successfully done what I am trying to do?
>
> Terry Adams
> Programmer
>
>
>
>
Received on Thu Feb 08 2001 - 11:50:07 CST