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



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

Answer / guest

Cause: 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.

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

Please add more information about this Error

Is This Answer Correct ?    1 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

PLS-01401: Identifier over 18 characters long

1 Answers  


ORA-36802: (XSTBLFUNC01) The OLAP_TABLE function must contain a DATAMAP that executes a FETCH command or a LIMITMAP.

1 Answers  


PCC-02373: Invalid declaration in EXEC SQL DECLARE section

1 Answers  


SQL*Loader-00938: partition load requested and string has enabled triggers or constraints

1 Answers  


ORA-15093: buffer only contains string bytes, I/O requested is string bytes

1 Answers  






LSX-00159: list content of multiple simple types is not allowed

1 Answers  


ORA-07266: sppst: invalid process number passed to sppst.

1 Answers  


AMD-00143: View name "string" must be fully qualified with the Owner.

1 Answers  


ORA-19581: no files have been named

1 Answers  


ORA-07431: fork failed

1 Answers  


SQL*Loader-00503: Error appending extension to file (string)

1 Answers  


ORA-30443: definition for filter string's item string is invalid

1 Answers  


Categories