Re: Help !

Yep,
You don't have any other rollback segment online than the rollback segment SYSTEM in the tablespace SYSTEM .
You'll need to have at least one other rollback segment in the tablespace SYSTEM.
Once that's done you can create rollback segments in any tablespace, usually that is a tablespace called RBS.

Hth,

Sybrand Bakker, Oracle DBA

Echoes <echoes_at_free.fr> wrote in message news:38E4C39D.4D37A5C3_at_free.fr...
> Hello,
>
> Everithing was running fine
> on my database until I tried
> to insert a 2-uple into a
> simple table and get this
> error :
>
> SQL> insert into id(name, id) values('frederique', 2);
> insert into id(name, id) values('frederique', 2)
> *
> ERROR at line 1:
> ORA-01552: cannot use system rollback segment for non-system tablespace
> 'USERS'
>
> Any idea ?
>
> Thanks
>
> Fabrice
Received on Fri Mar 31 2000 - 00:00:00 CST