| Data loading from unix to oracle [message #290260] |
Fri, 28 December 2007 04:09  |
vanathi
Messages: 74
Registered: December 2007
Location: India
|
Member |
|
|
Hi,
I am loading data from .csv files to oracle table everyday.
But now I couldnt load the data. The control file is not reading the data it seems.
Upto yesterday it was working(the same file).
Please advice.
Thanks in advance.
|
|
|
|
|
|
|
|
| Re: Data loading from unix to oracle [message #290268 is a reply to message #290264] |
Fri, 28 December 2007 04:25  |
vanathi
Messages: 74
Registered: December 2007
Location: India
|
Member |
|
|
Yes. I know. Thats why I have submitted my question here.
Totally 76000 records in the csv file. using sql loader only.
But it just reads 75 datas and rejects 51 from them.
only 5 records are going into table. I referred the log file.
I didnt change the control file and anything.
It is not reading the datas.
[Updated on: Fri, 28 December 2007 04:26] Report message to a moderator |
|
|
|
|
|
| Re: Data loading from unix to oracle [message #290291 is a reply to message #290287] |
Fri, 28 December 2007 05:08 |
vanathi
Messages: 74
Registered: December 2007
Location: India
|
Member |
|
|
the control file
load data
append
into table PARTCORE3
fields terminated by "," OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS (
CONTACTCODE CHAR,
RELATIONSHIPTYPE CHAR,
PORTFOLIOCODE CHAR,
PROCESSED CONSTANT "N",
ID__ "db_seq_PART.nextval"
)
It was working fine only. It was rejecting correctly.
But now it is rejecting correct datas also.
[Updated on: Fri, 28 December 2007 05:11] Report message to a moderator |
|
|
|
|
|
|
|
| Re: Data loading from unix to oracle [message #290299 is a reply to message #290296] |
Fri, 28 December 2007 05:38 |
 |
MarcS
Messages: 312
Registered: March 2007
Location: Antwerp
|
Senior Member |
|
|
Strange: all you need to know is withing that logfile 
When the number of errors reach 50 SQL*loader just stops
MAXIMUM ERROR COUNT EXCEEDED - Above statistics reflect partial run.
Table POSCORE3:
5 Rows successfully loaded.
51 Rows not loaded due to data errors.
0 Rows not loaded because all WHEN clauses were failed.
0 Rows not loaded because all fields were null.
5 rows have been loaded, 51 not because they had data errors.
Record 1: Rejected - Error on table POSCORE3, column CLIENTID.
ORA-12899: value too large for column "PMRDEV"."POSCORE3"."CLIENTID" (actual: 9, maximum: 8)
Record 2: Rejected - Error on table POSCORE3, column LTREPGL.
ORA-01722: invalid number
Check your data and see if it still valid.
Let me aks you another question: do you run it on a Windows-server?
I guess so, because you try to load a *.csv file.
Check the content of the *.csv file and see whether the field seperator is still a comma (,) and not a semicolon ( ; )
Which happens if International Settings has changes.
[Updated on: Fri, 28 December 2007 05:40] Report message to a moderator |
|
|
|
| Re: Data loading from unix to oracle [message #290303 is a reply to message #290299] |
Fri, 28 December 2007 05:45 |
vanathi
Messages: 74
Registered: December 2007
Location: India
|
Member |
|
|
Thank you friend.
I thought that the no of errors displayed is limited as 50.
As per your reply, If I am getting errors more than 50, It will stop. Ok...
I want to increase the errors allowed.
Is it possible?
If so, tell me.
I will get the csv files only. I checked the datas also.
It is not doing that for that day's data only.
I loaded the next day's data. It is working. But it is also stops after 50 errors.
[Updated on: Fri, 28 December 2007 05:49] Report message to a moderator |
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
