Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-01412: zero length not allowed for this datatype

1 Answers  


ORA-31505: cannot alter or drop predefined change set

1 Answers  


ORA-02398: exceeded procedure space usage

1 Answers  


ORA-27122: unable to protect memory

1 Answers  


DRG-52100: %(1)s returned internal error code string

1 Answers  






ORA-01635: rollback segment #string specified not available

1 Answers  


ORA-21702: object is not instantiated or has been de-instantiated in cache

1 Answers  


ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view

1 Answers  


IMG-00530: internal error while parsing command

1 Answers  


PCC-02014: Syntax error at line number, column number, file string:

1 Answers  


IMG-00502: invalid scale value

1 Answers  


ORA-32618: incorrect use of MODEL PREVIOUS function

1 Answers  






Categories