Server "Rows per Transaction" size

JPalatianos · Post by **JPalatianos** » Fri Apr 18, 2008 8:54 am

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

chulett · Post by **chulett** » Fri Apr 18, 2008 9:09 am

Which stage? For OCI it's 5 actually, but that doesn't change the answer - nope.

ray.wurlod · Post by **ray.wurlod** » Fri Apr 18, 2008 3:50 pm

0 means "all rows" are one transaction.

JPalatianos · Post by **JPalatianos** » Fri Apr 18, 2008 4:30 pm

What we are looking to do is load around 4 million records and would like to commit every 100,000 records or so.

chulett · Post by **chulett** » Fri Apr 18, 2008 6:07 pm

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.