ORA-01555: snapshot too old
Posted: 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
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