Home » RDBMS Server » Server Utilities » SQL loader problem
SQL loader problem [message #292795] |
Wed, 09 January 2008 21:10 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
I am loading data from csv to oracle.
I have attached the control file.
This file rejects
en017048,PD,N7C001013,cs,axp,usd,12202007,L,25.00,51.03,51.03,54.81,54.81,54.81,54.81,1370.14,1370.14,1370.14,1370.14,18.00,18.00,127 5.75,1275.75,-94.39,-94.39,-94.39,-94.39,0.00,0.00,usd,-94.39,-94.39,0.00,0.00,-94.39,-94.39,0.00,0.00
But reads
en017048,PD,N7C001054,ca,pgrxx,usd,12202007,L,,,,,,,,60.93,60.93,60.93,60.93,0.00,0.00,60.93,60.93,,,,,0.00,0.00,usd,,,,,,,,
when it rejects it says error that Error at column ltrepGL(last field) Invaild number.
Please advice.
[Updated on: Wed, 09 January 2008 21:17] Report message to a moderator
|
|
|
|
Re: SQL loader problem [message #292832 is a reply to message #292828] |
Thu, 10 January 2008 00:21 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
For the first doubt...no. I gave a sample only.
many records are rejected. similar to that...(all are having 0.00 at the last field)
I gave conatant 0.00 in control file...
Then it accepts all the rows...
I am new to this sqlloader. I am contnuing my friend's work.
As per my knowledge, if the sql loader finds number at the last field, it rejects.
|
|
|
|
|
|
Re: SQL loader problem [message #292871 is a reply to message #292868] |
Thu, 10 January 2008 01:47 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
Ok.
I have all the fields in the table as per the control file.
the sql loader rejects the record if it finds any numeric data at the last.
Otherwise it accepts. Please refer the sample datas.
|
|
|
|
|
|
Re: SQL loader problem [message #292881 is a reply to message #292877] |
Thu, 10 January 2008 02:04 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
please read the note below that
"the bolded is just 0.00 . But while puuting here it becomes 0.
so I used comma for that."
while pasting it here, without comma...it will become zero.
To differentiate that, I have put comma.
Please note.
|
|
|
|
|
|
|
Re: SQL loader problem [message #293095 is a reply to message #292986] |
Thu, 10 January 2008 21:41 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
vanathi
Messages: 74 Registered: December 2007 Location: India
|
Member |
|
|
rajavu1 wrote on Thu, 10 January 2008 18:49 |
No . Never , unless there is Error .
![Thumbs Up](images/smiley_icons/icon_thumbsup.gif)
Rajuvan
|
Yes. It is working for other dates. For one particular date's records, it is rejecting. What would be the error?
The same data is accepted in the another one date.(last field with 0.00). Please advice.
[Updated on: Thu, 10 January 2008 21:44] Report message to a moderator
|
|
|
Re: SQL loader problem [message #293139 is a reply to message #293095] |
Fri, 11 January 2008 00:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/45399.jpg) |
vamsi kasina
Messages: 2112 Registered: October 2003 Location: Cincinnati, OH
|
Senior Member |
|
|
In the control fileQuote: | asOfDate DATE "MM/DD/YYYY"
| In the data it is 12202007.
Changing it to MMDDYYYY helps you? Have a try.
By
Vamsi
|
|
|
Goto Forum:
Current Time: Sat Sep 07 18:04:26 CDT 2024
|