SQL*Loader-00609: value used for ROWS parameter changed from
number to number
- 1 Answers
- 13187 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-00238: operation would reuse a filename that is part of the database
ORA-32845: Messaging Gateway agent is already running
ORA-16772: Error in switching over between primary and standby databases
ORA-14454: attempt to reference temporary table in a referential integrity constraint
QSM-00999: Advisor feature is not currently implemented
ORA-25017: cannot reference NEW ROWID for movable rows in before triggers
DRG-13008: cannot remove the DEFAULT sub lexer
ORA-00065: initialization of FIXED_DATE failed
TNS-12500: TNS:listener failed to start a dedicated server process
PCC-02345: SQLCHECK=SEMANTICS must be given when embedded PL/SQL blocks are used
ORA-38773: cannot add data file 'string' - file already part of database
PCC-02330: expecting an expression of integer type
Oracle Errors 
