ok so let me chirp in as well .. another way of
preventing 1555 is to first do a full table scan on
the table you are about to mess with .. to prevent
delayed block cleanout effect .. go figure ;)
Deepak
- "Gogala, Mladen" <MGogala_at_oxhp.com> wrote:
> Another way of avoiding ora-1555 errors is issuing
> 'LOCK TABLE xxx
> in EXCLUSIVE MODE' before issuing a select
> statement. That will make
> sure that no transaction is modifying the table
> you're reading and
> you will not get any ora-1555 errors. This is
> especially useful in
> an OLTP environment. There might be a problem with
> job security,
> however....
>
>
> -----Original Message-----
> Sent: Monday, November 19, 2001 12:00 PM
> To: Multiple recipients of list ORACLE-L
>
>
> The ORA-1555 is a read consistency error. The
> information from the rollback segments needed to
> create a read-consistent view of the data is not
> available. Usually because the information has been
> overwritten or the extents containing this
> information
> have been deallocated (e.g. if optimal is set).
>
> Until 9i, where you can use automatic undo to avoid
> these errors, the best way is to create dummy
> transcations in each of the online RBS's before
> starting the export and leave them uncomitted until
> the export completes. This will prevent the
> rollback
> segments from wrapping around and overwriting the
> extents that contained uncomitted transactions when
> the export began. Of course this means you're
> likely
> to generate a lot more rollback than usual so you'll
> need to monitor the space in the RBS tablespaces to
> avoid getting extent allocation errors.
>
> Check Steve Adams' site for a set of scripts to
> assist
> you with this:
> http://www.ixora.com.au
> Scripts > Rollback Segments
>
> HTH,
>
> -- Anita
>
> --- Jackson Dumas <tjaros_at_webmail.co.za> wrote:
> >
> > Yeah
> >
> > I had a problem recently were I was exporting a
> > 45Gigg database, the
> > export will continue until at a end it will come
> up
> > with a warning
> > that export was completed successfully with
> warnings
> > because rollback
> > segment was too old. I increased the tablespace
> RBS
> > where the rollback
> > segments are residing and also created some more
> > rollback segments.
> > This did not work also, I had a problem similar to
> > this but this was
> > happening when the user was trying to delete some
> > records with a where
> > clause, it would come up with the error rollback
> > segment too old.
> > Can somebody give me an idea of how to go about
> this
> > problem, I would
> > appreciate you input dearly
> >
> > Thank you,
> >
> > Mtabaruka !!!!!
> >
>
> > http://www.webmail.co.za the South-African free
> > email service
> > --
> > Please see the official ORACLE-L FAQ:
> > http://www.orafaq.com
> > --
> > Author: Jackson Dumas
> > INET: tjaros_at_webmail.co.za
> >
> > 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).
>
>
> __________________________________________________
> Do You Yahoo!?
> Find the one for you at Yahoo! Personals
> http://personals.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: A. Bardeen
> INET: abardeen1_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: Gogala, Mladen
> INET: MGogala_at_oxhp.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).
Do You Yahoo!?
Find the one for you at Yahoo! Personals
http://personals.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Deepak Thapliyal
INET: deepakthapliyal_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 Nov 19 2001 - 13:50:29 CST