ORA-01555 (snapshot too old) after a db crash: How to recover?
Database 9.2.0.6 / Win XP Pro SP2:
I'll get everytime an ORA-01555 error when submitting a SELECT * on a particular table (only on one, all others are ok). The same will happen if an export of that table is made (then the export is aborted).
Since there is no user activity and also a reboot of the instance was done, I do not consider this as a run-time problem (e.g. to less space in UNDO). It seems to happen as a result of a database crash (power failure)
Now my question: How can I "reset" this behaviour? I don't need to care about that particular row that is causing this problem. Of course, I could recreate the table, but first I want to understand what was gone wrong...
Any hints are highly appreciated. Thanks!
Daniel