Data loading [message #290728] |
Mon, 31 December 2007 05:14  |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Hi,
I am loading data from csv to oracle table using control files.
The line of that csv includes the header line having the details like date and time, name etc.
But the count in the table after loading also it shows the same count.
It should reject the header row. I am loading many files.
They are rejecting the header row of their csv.
But I am getting this type of output in that particular file.
Also I checked for the header in the table. It is not there.
Please advice.
Thanks in advance.
|
|
|
|
|
|
Re: Data loading [message #290744 is a reply to message #290728] |
Mon, 31 December 2007 06:18  |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Thank you friends.I found my mistake.
load data
append
into table PARTCORE3
fields terminated by "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
FIELD FILLER,
CONTACTCODE CHAR,
RELATIONSHIPTYPE CHAR,
PORTFOLIOCODE CHAR,
PROCESSED CONSTANT "N",
ID__ "db_seq_PART.nextval"
)
This is my control file. Here that partcore3 is having that first column contactcode varchar(32). The loader is checking the header. It is very less (<32). So it is taking the header row also. The header is also inside the table.
I couldnt find that. Sorry friends.
I used Michel's idea. It is working.
Thanks Michel and Littlefoot.
|
|
|