Are you using transaction size as 0 for target (Oracle).
Moreover you need not change Siebel, it's the problem with Oracle rollback segment.
Solns:
1. Increase the rollback segment size.
or
2. Experiment with transaction size other than 0 (but here you would need to be a bit careful since specifying transaction size means specifying commit frequency).
ROLLBACK SEGMENT ERROR
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
If your DBA still couldn't help you, then you could consider splitting your load into smaller segments. Load the data into sequential files and then you could bulk load them into Oracle. Thus overcoming the rollback segment constraints. If you think that would be useful search for posts by kcbland on this topic.
HTH
HTH
-
- Participant
- Posts: 65
- Joined: Fri Nov 19, 2004 12:00 am
Yes, but with a great big CAVEAT.Poornagirija wrote:We are using transaction size of 5000 but thats for commit rt?
Make sure you are not using the 'Transaction Size' box on the General tab on the Input of the OCI stage, that's just there for 'backwards compatability' and to confuse people. It is ignored.
Check the value in the 'Transaction Handling' tab on the stage where it says 'Rows per transaction' - that one is the real one and the one that is your commit level. That's probably still at the default of zero.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers