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