ORA-01555: snapshot too old

rajendharreddy · Post by **rajendharreddy** » Thu Jan 16, 2014 7:17 am

Hi

I got the following error while extracting data from a table and insering in to the hash file.

in Select statement we have 7 fields. while creating hash file we are keeping 6 fields as a key column.

Kindly give me your valuable suggestions to fix the job.

LkFBLk..FormatKey: ORA-12801: error signaled in parallel query server P069
ORA-01555: snapshot too old: rollback segment number 11 with name "RBS10" too small

chulett · Post by **chulett** » Thu Jan 16, 2014 8:12 am

This has nothing to do with DataStage, in case you were wondering. While you could search online for that Oracle error, I'd suggest having a chat with your DBA for an explanation as to what is going on. They may be able to increase the amount of 'rollback' on the instance or ask you to run the job at a time when the source data isn't rapidly changing.