| Sql*loader for large # of records (7500) [message #69947] |
Thu, 21 March 2002 13:10  |
Steven Pelletier
Messages: 3
Registered: March 2002
|
Junior Member |
|
|
I am having trouble with loading 7500 items into a table. The sqlldr stops at 640. Where is the parameter that allows me to adjust this?
The current statement I am using is as follows.
Sqlldr username/password item.ctl test.log test.bad test.csv load=7500.
the item.ctl looks like this.
load data
infile 'test.csv'
badfile 'test.bad'
discardfile 'test.dsc'
Insert into table items
fields terminated by "," optionally enclosed by '"'
(ID integer external,
SPEC_DESCRIPTION char,
IMAGEPATH char,
INVENTORY integer external,
SEGMENT1 char,
SEGMENT2 char,
CAT_SEGMENT1 char,
CAT_SEGMENT2 char,
TEMPLATE_NAME char,
PRICE char)
Thank you for your help,
Steven
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
