Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'
> Rusty Fadgen wrote:
>
> What is:??
>
> ORA-01552: cannot use system rollback segment for non-system
> tablespace 'USERS'
>
>
> And How do I Fix it?
>
>
> I was trying to update a table and recieved this error
>
Rusty,
Do you have one or more dedicated tablespace(s) for rollback segments?
Is it (are they) online?
Are the public rollback segs in the rbs tablespace(s) online?
Paul Received on Sat May 12 2001 - 00:16:48 CDT