Hi, The snapshot too old error comes when someone has started a query on one table and at the same time some transaction is going on. So at this time the select query will read from rollback segment to create a consistent view in time. Now in what happens select query has started reading the rollback segment and that transaction has completed. At this particular time the snapshot too old error will come. The only solution i can tell u to increase your rollback segment size and also increase your export buffer ( so that faster export can be done as snapshot is also related to time). Or do your export when least amount of activity is going on in db.
Regards Darshan Singh -----Original Message----- Williams Sent: Friday, October 18, 2002 4:14 PM To: Multiple recipients of list ORACLE-L I am performing an export of a set of very large tables. I am not using CONSISTENT mode. The exports are failing due to snapshot too old errors. The application uses many small rollback segments, but has one large one for big transactions. Is it possible to force the export to use the large segment without taking all the others (except System) offline? I have seen this question asked on the list before, but did not find a definitive follow-up answer. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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: Darshan Singh INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- 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).
