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-02059: ORA-2PC-CRASH-TEST-string in commit comment

1 Answers  


IMP-00030: failed to create file string for write

1 Answers  


ORA-13203: failed to read USER_SDO_GEOM_METADATA view

1 Answers  


ORA-13441: GeoRaster metadata SRS error

1 Answers  


LPX-00310: element ~S not found in ~S

1 Answers  






ORA-28527: Heterogeneous Services datatype mapping error

1 Answers  


SQL*Loader-00293: Missing XMLTYPE directive in control file for table string

1 Answers  


TNS-00074: * status - get statistics from the process_name

1 Answers  


NNL-00264: Request forwarding is now disabled

1 Answers  


SQL*Loader-00292: ROWS parameter ignored when a LOB column is loaded

1 Answers  


ORA-22619: all collection elements have already been accessed

1 Answers  


ORA-12654: Authentication conversion failed

1 Answers  


Categories