Snapshot too old (rollback) Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Snapshot too old (rollback)

  1. #1
    Join Date
    Jan 2002
    one of the users running big batch job and he got the ORA-01555: snapshot tool old

    I did ask him to commit every 200 rows and I also used to large rollback segment in my database.

    what esle should I do to fix this


  2. #2
    Join Date
    Nov 2000
    Use the Search link and search for snapshot too old and ora-1555. This topic has been discussed hundreds of times in this forum.
    Jeff Hunter
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width