Jackson, As you have discovered , the issue is that other transactions are overwriting your read consistent view of the tables. Options could include 1) Running the export at a quite time (sounds like you have tried that but with only partial suucess) 2) Taking a direct export which reduces the time very considerably (especially if you do it at weekend) 3) Take subsets of the data using either a parameter file with export with a list of tables you are interested in and multiple exports (different parameter files of course) 4) Using the query option of export to again take subsets of data from the biggest tables
Using options 3+ 4 means you need to put in some sort of means of capturing changes ( a IUD trigger to capture rowid's) but it will be very difficult to ensure integrity. Your last sentence is very worrying, I hope you are not using export as a means of backing up the database because from what you have said that is totally unreliable. Out of the above options only 1) will give you any sort of consistent view of the tables. John -----Original Message----- Sent: 21 February 2003 10:00 To: Multiple recipients of list ORACLE-L Hi all I have a problem when doing an export in one of ourt production databases. The export fails with ORA-01555, snapshot too old error. I have increased the number of rollback segments and their sizes on the database. Also I have went to an extent of specifying the parameter constent=n on my script but backups fails. The worst part is this export runs for a long time and then fails, more than 24 hours. The only time that this export succeed is over the weekend, because most of the time few people are working or not at all. Now I have tried to start it after hours but as I said it still takes long and end up failing the next day. Could somebody help me here, this is very critical to be running production without proper backups .....! Thanx _______________________________________________________________ http://www.webmail.co.za the South-African free email service NetWiseGurus.Com Portal - Your Own Internet Business Today! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jackson Dumas 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.net -- Author: <[EMAIL PROTECTED] 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).
