RE: Rollback Segment Too Old !!!!!!!
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" <[EMAIL PROTECTED]> 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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 remove
Re: Rollback Segment Too Old !!!!!!!
Hey Anita, this is really a cool workaround .. who thought these dummy transactions were so damn smart !!! this implementation of dummy Xns i am hearing about for the first time .. let me admit ;) Great mail!! Thx Deepak --- "A. Bardeen" <[EMAIL PROTECTED]> wrote: > 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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Rollback Segment Too Old !!!!!!!
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Rollback Segment Too Old !!!!!!!
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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Rollback Segment Too Old !!!!!!!
Hi Mr Dumas , Why not using direct path load In export specify : Direct = y Regards > -Original Message- > From: ASHRAF SALAYMEH [SMTP:[EMAIL PROTECTED]] > Sent: Saturday, November 17, 2001 1:30 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Rollback Segment Too Old !!! > > I think you forgot to assign a transaction to the > increased RBS > > Suppose the increased RBS is RBS2 then > > SET TRANSACTION USE ROLLBACK SEGMENT RBS2; > > After that do an export again . > > I think it will work. > > --- Jackson Dumas <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: ASHRAF SALAYMEH > INET: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: Ahmed Gholam Hussain INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Rollback Segment Too Old !!!!!!!
Ashraf, You can't do that with an export. Jared On Saturday 17 November 2001 02:00, ASHRAF SALAYMEH wrote: > I think you forgot to assign a transaction to the > increased RBS > > Suppose the increased RBS is RBS2 then > > SET TRANSACTION USE ROLLBACK SEGMENT RBS2; > > After that do an export again . > > I think it will work. > > --- Jackson Dumas <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > > > 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: [EMAIL PROTECTED] (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: Jared Still INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Rollback Segment Too Old !!!!!!!
I think you forgot to assign a transaction to the increased RBS Suppose the increased RBS is RBS2 then SET TRANSACTION USE ROLLBACK SEGMENT RBS2; After that do an export again . I think it will work. --- Jackson Dumas <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Rollback Segment Too Old !!!!!!!
I think you forgot to assign a transaction to the increased RBS Suppose the increased RBS is RBS2 then SET TRANSACTION USE ROLLBACK SEGMENT RBS2; After that do an export again . I think it will work. --- Jackson Dumas <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: ASHRAF SALAYMEH INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
RE: Rollback Segment Too Old !!!!!!!
metalink documents 10630.1 69464.1 62005.1 and 45895.1 will help The key is to hold on to committed values in the rollback segments as long as possible. You can add rollback segments, increase their size (i.e. increase MINEXTENTS), avoid using OPTIMAL (maybe a debateable suggestion) but do not overlook analyzing the database activity at the time of the 1055. Consistent views of large amounts of data in a highly active database may be impossible. Kurt Wiegand IBM Global Services Cable & Wireless Communications 703 760-3619 -Original Message- Sent: Friday, November 16, 2001 9:30 AM To: Multiple recipients of list ORACLE-L 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: Wiegand, Kurt INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
Re: Rollback Segment Too Old !!!!!!!
For a consistent read, the export needs to the rollback segments, but they are being recycled by other txns in your db. So you'll need one or more of: - larger rollback segs - less activity whilst your doing your export - faster exports hth connor --- Jackson Dumas <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
