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