Snapshot too old (rollback)

[ashley75]

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

Thanks

[marist89]

Use the Search link http://www.dbasupport.com/forums/search.php and search for snapshot too old and ora-1555. This topic has been discussed hundreds of times in this forum.