Home » RDBMS Server » Server Utilities » sqlldr issue loading huge files (Oracle 11GR2)
| sqlldr issue loading huge files [message #622047] |
Wed, 20 August 2014 11:31  |
 |
anilkumar.cy@gmail.com
Messages: 2
Registered: August 2014
Location: United States
|
Junior Member |
|
|
Hi - I am trying to load a .txt file into a table using sqlldr through the windows command prompt. The input file size is around 1 GB. Target table is empty. Here is the command and the control file content. The issue i am facing is as soon as i run this command, i am getting an error from windows that sqlldr.exe has stopped running. Any inputs on resolving this issue would be greatly appreciated.
sqlldr userid=uid/pwd@dbname control=kbm_load.ctl
OPTIONS (DIRECT=TRUE, ROWS=10000)
LOAD DATA
INFILE <input_file>
INTO TABLE CX_MKTG_EXTNL_CNSMR_REF
(
FIRST_NAME POSITION(1:15),
MID_NAME POSITION(16:1),
LAST_NAME POSITION(17:15),
SUFFIX POSITION(42:15),
ADDRESS POSITION(57:40),
CITY POSITION(97:13),
STATE POSITION(110:2),
ZIP POSITION(112:5),
ZIP_P4 POSITION(117:4),
CARRIER_ROUTE POSITION(122:4),
DMA_CODE POSITION(131:4),
CBSA_CODE POSITION(135:5),
LATITUDE POSITION(141:9),
LONGITUDE POSITION(150:9),
CNSMR_ID POSITION(239:12),
GENDER POSITION(254:1),
RACE POSITION(255:1),
FAMILY_POSITION_CODE POSITION(256:1),
LENGTH_OF_RESIDENCE POSITION(258:2),
HOME_STATUS POSITION(260:1),
HOME_VALUE POSITION(261:4),
APT POSITION(265:1),
EST_HOUSEHOLD_INCOME POSITION(266:1),
NET_HOUSEHOLD_INCOME POSITION(267:1),
HOUSEHOLD_INCOME_RANK POSITION(268:1),
EST_HOUSEHOLD_INCOME_QTY POSITION(269:1),
MAIL_RESPONSE POSITION(270:1),
MARRIED_FLAG POSITION(272:1),
ADULT_QTY POSITION(273:3),
HOUSEHOLD_IND_QTY POSITION(276:3),
CHILDREN_QTY POSITION(282:3),
HOUSE_BSNS_FLAG POSITION(300:1),
CALC_AGE POSITION(327:2),
DOB_MONTH POSITION(329:2),
CREDIT_CARD_FLAG POSITION(337:1),
RETAIL_CARD_FLAG POSITION(338:1),
CREDIT_RLTN_FLAG POSITION(339:1),
CREDIT_SRETAIL_RLTN_FLAG POSITION(340:1),
CREDIT_LDEPT_RLTN_FLAG POSITION(341:1),
CREDIT_MRETAIL_RLTN_FLAG POSITION(342:1),
CREDIT_HRETAIL_RLTN_FLAG POSITION(343:1),
HOUSEHOLD_COMP_FLAG POSITION(344:1),
GENERS POSITION(345:2),
ETHNICITY POSITION(347:2),
RELIGION POSITION(349:1),
LANG_PREF POSITION(350:2),
HISPANIC_ETHNICITY POSITION(352:2),
ASSIMILATION_CODE POSITION(354:1),
ETHNICITY_GROUP POSITION(355:1),
ETHNICITY_TECH POSITION(356:2),
ETHNICITY_TECH_LANG POSITION(358:2)
)
|
|
|
|
|
|
|
|
|
|
|
|
| Re: sqlldr issue loading huge files [message #622067 is a reply to message #622047] |
Wed, 20 August 2014 12:53  |
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
|
Senior Member |
|
|
|
All of your column definitions are incorrect, except the first one. The numbers in parenthesis should be start and end position. Except the first one, the end position is less than the start position).
|
|
|
|
Goto Forum:
Current Time: Thu Jan 30 19:58:48 CST 2025
|
] 
Blog
Search
Help
Members
Register
Login
Home
