How to fix the Oracle error SQL*Loader-00609: value used for ROWS parameter changed from number to number?

In this post, you’ll learn more about the Oracle ErrorSQL*Loader-00609: value used for ROWS parameter changed from number to number with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

SQL*Loader-00609: value used for ROWS parameter changed from number to number

Reason for the Error SQL*Loader-00609: value used for ROWS parameter changed from number to number

SQL Loader adjusted the value it was using for the ROWS parameter to the new value reported. This is an informational message and not an error. SQL Loader will adjust the value of the ROWS parameter if the amount of memory specified by BINDSIZE is not large enough to hold data for the number of rows specified. SQL Loader will also change the value of the ROWS parameter for conventional path loads if the value is larger than 65534. Conventional path load can load at most 65534 rows at a time.

How to fix the Error SQL*Loader-00609: value used for ROWS parameter changed from number to number ?

You can fix this error in Oracle by following the below steps

If the limit of 65534 rows for conventional path load is not being reached, then try increasing the value of BINDSIZE.