Give me the steps that How can I get the ORA-1555 snapshot too old error in Oracle9i.
Printable View
Give me the steps that How can I get the ORA-1555 snapshot too old error in Oracle9i.
Have a search at http://asktom.oracle.com/
Open a cursor selecting everything from a table.
fetch the first row.
go away on holiday for a week while leaving lots of users and batch jobs to update the table.
come back and try to fetch the rest of the rows.