Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: ORA-01552 : (
Make sure your non system rollback segments are
online.
--- "Rivera, Claudia" <crivera_at_utep.edu> wrote:
> I just trasnferred some account from an oracle
> database on solaris to an
> oracle database on linux.
> Everything looked perfect, UNTIL I tried to insert
> or modify records from
> tables that do not belong to the SYSTEM
> table space.
> It gives me the following error:
>
>
> ORA-01552: cannot use system rollback segment for
> non-system tablespace
> 'USERS'
>
> What can I do? What is happening?
>
> TIA
>
>
>
> --
> Author: Rivera, Claudia
> INET: crivera_at_utep.edu
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>