SQL*Loader-00609: value used for ROWS parameter changed from
number to number
- 1 Answers
- 12691 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 |
ORA-14289: cannot make local index partition of Composite Range partitioned table unusable
ORA-27072: File I/O error
ORA-29707: inconsistent value string for initialization parameter string with other instances
ORA-12598: TNS:banner registration failed
TNS-00117: Internal error- No data passed through pump
NZE-29022: Operation is being attempted on the wrong side of the client/server connection.
SQL-02109: Inconsistent host cache. Host reference is out of range
ORA-16198: Timeout incurred on internal channel during remote archival
ORA-01672: controlfile may be missing files or have extra ones
ORA-26518: push queue synchronization error detected
ORA-28172: distinguished name not provided by proxy
ORA-19209: invalid or unsupported formatting argument
Oracle Errors 
