Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'

Re: ORA-01552: cannot use system rollback segment for non-system tablespace 'USERS'

From: Paul Drake <paled_at_home.com>
Date: Sat, 12 May 2001 05:16:48 GMT
Message-ID: <3AFCC741.4491E100@home.com>

> 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US