Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

DRG-51100: invalid program argument index

1 Answers  


KUP-04089: column transform string is not the name of a table column

1 Answers  


SQL*Loader-00647: Integer to number conversion error

1 Answers  


ORA-12823: default degree of parallelism may not be specified here

1 Answers  


ORA-29284: file read error

1 Answers  


ORA-01127: database name 'string' exceeds size limit of string characters

1 Answers  


QSM-01059: HAVING clause in the query block is malformed

1 Answers  


QSM-02009: non-inner join

1 Answers  


ORA-06580: Hash Join ran out of memory while keeping large rows in memory

1 Answers  


ORA-01664: Transaction which has expanded the Sort Segment has aborted

1 Answers  


AMD-00132: dimension #string: RDBMS GID column data type not specified

1 Answers  


ORA-36682: (XSDPART20) Partition name string appears twice.

1 Answers  


Categories