Oracle Stage Commit Point
Posted: Wed Nov 22, 2006 1:18 am
Hi all,
I have a small question for research purposes.
I have a job that loads data from an sql server stage to Oracle stage. My question involves what is the commit interval set for the oracle stage by default?
Let's say my sql server source involves 10 million records, I don't think it will only commit after inserting 10 million records? It would be disasterous if the connection cuts of in between.
I can't seem to find a setting in Oracle Stage pertaining to this option (Specifying commit intervals).
Would any of you guys know? Thanks in advanced.
I have a small question for research purposes.
I have a job that loads data from an sql server stage to Oracle stage. My question involves what is the commit interval set for the oracle stage by default?
Let's say my sql server source involves 10 million records, I don't think it will only commit after inserting 10 million records? It would be disasterous if the connection cuts of in between.
I can't seem to find a setting in Oracle Stage pertaining to this option (Specifying commit intervals).
Would any of you guys know? Thanks in advanced.