RE: Please help with ORA-01555 Snapshot too old

[Dawtrey, Lindsay L]

Title: Message

You can try committing less frequently in the batch load e.g. if you are committing every 10000 rows then try every 30000 (assuming of course that the you have space left in the RBS to allow for this) or you can try adding rollback segments. Metalink docs give some good ideas as to the real causes of this error. The error message text itself is sometimes misleading. Cheers Lindsay  -----Original Message----- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 22, 2003 5:04 PM To: Multiple recipients of list ORACLE-L Subject: Please help with ORA-01555 Snapshot too old Help!   I have a production and a test database, both with 3000mg RBS tablespaces with two datafiles.  Both have db_block_buffers set at 1000.  The only difference is the production db has 7 rollback segments and the test db has 8.  The rollback segments are sized at 50mg each on both databases.   The problem is, at night when the batch load is running (by itself), the load fails with a ORA-01555.  The data is the same on both loads.  Nothing else is going on in the database during the load.   Any ideas?   Ron   __________________________________________________________________________________________________________________________________ For information about the Standard Bank group visit our web site <www.standardbank.co.za> __________________________________________________________________________________________________________________________________   Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the official business of Standard Bank Group Limited  is proprietary to the group. It is confidential, legally privileged and protected by law. Standard Bank does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of the group. The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way. Standard Bank can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. ___________________________________________________________________________________________________________________________________