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
ORA-01555: snapshot too old
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 46
- Joined: Tue Aug 21, 2007 5:39 am
- Location: Bangalore, India
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.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers