Page 1 of 1
Server "Rows per Transaction" size
Posted: Fri Apr 18, 2008 8:54 am
by JPalatianos
Hi,
Currently in our designer the "Rows Per Transaction" tab only allows 4 digits(up to 9999). Is there any way to increase this.
Thanks - - John
Posted: Fri Apr 18, 2008 9:09 am
by chulett
Which stage? For OCI it's 5 actually, but that doesn't change the answer - nope.
Posted: Fri Apr 18, 2008 3:50 pm
by ray.wurlod
0 means "all rows" are one transaction.
Posted: Fri Apr 18, 2008 4:30 pm
by JPalatianos
What we are looking to do is load around 4 million records and would like to commit every 100,000 records or so.
Posted: Fri Apr 18, 2008 6:07 pm
by chulett
For that, you'd need to switch to a manual bulk load and specify that commit level as part of the control files. Or use a stored procedure.