RE: ORA-01555: snapshot too old: rollback segment number...

Hello Viktor

Regarding the rollback segments, I heard from Oracle that you need to allocate them
with min extents=20.
This will cause users to get their own extents and the chance that a new update will overwrite
an old update that you need will decrease. Check metalink. they have a paper on this error (if I remember correctly)

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Karniotis, Stephen [SMTP:Stephen_Karniotis_at_compuware.com]
> Sent: Tue, January 15, 2002 8:05 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORA-01555: snapshot too old: rollback segment number...
>
> You can export with CONSISTENT=N; a consistent view of the data will not
> be
> achieved. You can also increase the size of your rollback segments to
> accommodate large queries while updates are being performed. There is not
> much else you can do on this one.
>
> Thank You
>
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct: (248) 865-4350
> Mobile: (248) 408-2918
> Email: Stephen.Karniotis_at_Compuware.com
> Web: www.compuware.com
>
>
> -----Original Message-----
> Sent: Tuesday, January 15, 2002 12:20 PM
> To: Multiple recipients of list ORACLE-L
> Subject: ORA-01555: snapshot too old: rollback segment number...
>
> Hi all,
>
> Last nignt when we were expring data for one of our
> databases, this error ocurred:
>
> ORA-01555: snapshot too old: rollback segment number
> 3 with name "R02") offset=(0).
>
> Now, we were able to once again export and load data
> this morning. And there was no error.
>
> What is the best aproach to try to eliminate this
> error in the future?
>
> Any suggestions apreciated.
>
> Thanks
>
> Regards
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Send FREE video emails in Yahoo! Mail!
> http://promo.yahoo.com/videomail/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Viktor
> INET: stant_98_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).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Karniotis, Stephen
> INET: Stephen_Karniotis_at_compuware.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).
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> This e-mail was scanned by the eSafe Mail Gateway
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

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).