| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 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 !!!!!
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).
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 Fri Nov 16 2001 - 11:17:42 CST
 |
 |