Re: Help !

ORA-01552 cannot use system rollback segment for non-system tablespace 'string'

Cause: An attempt was made to use the system rollback segment for operations involving non-system tablespace. If this is a clone database then this will happen when attempting any data modification outside of the system tablespace. Only the system rollback segment can be online in a clone database.

Action: Create one or more private/public segment(s), shut down and restart. May need to modify the initialization parameter ROLLBACK_SEGMENTS to acquire private rollback segment. If this is a clone database being used for tablespace point in time recovery then this operation is not allowed.

Cheers,
Juhan

Echoes wrote:
>
> 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