Rollback Segment Too Old !!!!!!!

From: Jackson Dumas <tjaros_at_webmail.co.za>
Date: Fri, 16 Nov 2001 06:52:04 -0800
Message-ID: <F001.003C756C.20011116063023@fatcity.com>

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). Received on Fri Nov 16 2001 - 08:52:04 CST