SQL Loader loads only 1 record [message #523936] |
Wed, 21 September 2011 03:56 |
|
sampathku
Messages: 1 Registered: September 2011
|
Junior Member |
|
|
Hi Barbara,
This could be a silly mistake, but the SQL loader somehow is loading only first record. The data file is a csv and the end of line character is a new line. Some text fields have multiple new lines.
Here is my control file
load data
infile '/home/devo/c0397105/RuleImport/testLoad/dummyLoad.csv'
Truncate
into table DUMMY_LOAD_TABLE
fields terminated by "," optionally enclosed by '"'
( ID "to_number(:ID)",REQUESTED_GROUP,PURPOSE,COMMENTS)
CREATE TABLE DUMMY_LOAD_TABLE
(
ID NUMBER NOT NULL,
REQUESTED_GROUP VARCHAR2(100),
PURPOSE VARCHAR2(200),
COMMENTS VARCHAR2(300),
CONSTRAINT PK_DUMMY_LOAD_TABLE PRIMARY KEY(ID) USING INDEX TABLESPACE INDEX_TS
)
3,IST Helpline,Notify HL when corporate voice systems are been changed,"8/3 - n/a for corp sys rollout
2/7 - updated for GNCS rollout"
4,IST Helpline,Notify HL when Austin voice systems are been changed,"8/3 - n/a for corp sys rollout
2/7 - updated for GNCS rollout"
5,IST Helpline,Notify HL when retail stores are been changed,"8/3 - n/a for corp sys rollout
UPDATED 7/15
We don't have Retail resource type as Dependent System now; the rule will be changed later when Dependent Systems can accept resource types other than application"
|
|
|