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

ORA-13002: specified level is out of range

1 Answers  


PCB-00629: Host variable is not of Internal LOB type

1 Answers  


TNS-04069: Sleeping for number seconds...

1 Answers  


ORA-29928: duplicate default selectivity specified

1 Answers  


RMAN-06155: validation failed for controlfile copy

1 Answers  


ORA-02055: distributed update operation failed; rollback required

1 Answers  


NNL-00299: Scheduled server cache dump to occur in string

1 Answers  


LSX-00235: invalid URI "~S"

1 Answers  


DRG-11518: text table string does not have a LONG or LONG RAW column

1 Answers  


ORA-13617: The specified task string already executing

1 Answers  


NID-00128: Cannot revert change of database, change not in progress

1 Answers  


ORA-32690: Hash Table Infrastructure ran out of memory

1 Answers  


Categories