ORA-01555 : Snapshot too old

[Josselin]

Hi all,

when using an ETL progarm which operates multiple lookup in base tables, I've got the following error message : ORA-01555 : Snapshot too old...

Would be happy to have your feedback.


Josselin.

 

[jimbopalmer]

this thread discusses this error message in depth and heatedly

http://tek-tips.com/viewthread.cfm?SQID=628107&SPID=186&newpid=186&page=1

I tried to remain child-like, all I acheived was childish.

 

[BJCooperIT]

Try this thread:
ORA-01555: snapshot too old - Problem with Rollback Segments? thread186-628107

^{Beware of false knowledge; it is more dangerous than ignorance. ~George Bernard Shaw}
Systems Project Analyst/Custom Forms & PL/SQL - Oracle/Windows

 

[olli2003]

Hi Josseline

Don't worry of this error, that isn't strange one.
Please set the Oracle Paramterfile
'undo_supress_errors' to true.

Logon to your Oracle Database as system/manager via SQLPLUS

>alter system set undo_supress_errors=true

Good luck!

Regards
Oliver