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
Printable View
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
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.