Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-01552 : (
Yes, this was the problem
Thanks a lot.
-----Original Message-----
From: james ellis [mailto:jellis24_gso_at_yahoo.com]
Sent: Monday, August 28, 2000 3:59 PM
To: Multiple recipients of list ORACLE-L
Subject: 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
>
-- Author: james ellis INET: jellis24_gso_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Mon Aug 28 2000 - 16:42:46 CDT