SQL*Loader-00609: value used for ROWS parameter changed from
number to number
- 1 Answers
- 13273 Views
- I also Faced
- E-Mail Answers
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 |
RMAN-06038: recovery catalog package detected an error
QSM-01030: materialized view, string, has PL/SQL functions in ENFORCED integrity mode
PLS-00500: invalid operator binding
ORA-16733: Error executing dbms_logstdby.unskip procedure
IMG-00845: internal image index allocation failed
AMD-00125: dimension #string: analytic workspace column level dimension not specified
ORA-27101: shared memory realm does not exist
PCB-00404: %s
TNS-12165: TNS:Trying to write trace file into swap space.
ORA-19606: Cannot copy or restore to snapshot controlfile
PCC-00071: Unable to open message file.
ORA-06310: IPA: Environment variable(s) not set
Oracle Errors 
