Special Language Character [message #301491] |
Wed, 20 February 2008 19:02 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
monisha
Messages: 8 Registered: February 2008
|
Junior Member |
|
|
Hi
I am trying to upload data from a flat file in my database through sql loader. My flat file contains data for example
Sancán
Sánchez-Galán
López, Tomás
Ramírez
Arróliga García
these records are not getting inserted in my table and I have also created a bad file to log the bad data and all these records are inserted in that bad file. Is there any way how I can modify my control file and get the data inserted in my table
I really need this data.
my control file is in this manner
load data
replace
into table EPH_STAGING
fields terminated by '|'
trailing nullcols
(
UNIQUE_IDENTIFIER NULLIF UNIQUE_IDENTIFIER=BLANKS "TRIM(:UNIQUE_IDENTIFIER)",
CHEVRON_LOGON_ID NULLIF CHEVRON_LOGON_ID=BLANKS "TRIM(:CHEVRON_LOGON_ID)",
SUPERVISOR_ID NULLIF SUPERVISOR_ID=BLANKS "TRIM(:SUPERVISOR_ID)",
SUPERVISOR_NAME NULLIF SUPERVISOR_NAME=BLANKS "TRIM(:SUPERVISOR_NAME)",
Thanks
Monisha
[Updated on: Wed, 20 February 2008 19:26] Report message to a moderator
|
|
|
|
Re: Special Language Character [message #302001 is a reply to message #301552] |
Fri, 22 February 2008 11:49 ![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) |
monisha
Messages: 8 Registered: February 2008
|
Junior Member |
|
|
Hi,
I am sending you the control file I am using and these special characters occur in my first name or last name coulumn.
These records are there in my flat file but not geting inserted in my database (table)
Sancán
Sánchez-Galán
López, Tomás
Ramírez
Arróliga García
See if you can help
Thanks
Monisha.
|
|
|
|
|
Re: Special Language Character [message #302010 is a reply to message #302009] |
Fri, 22 February 2008 12:34 ![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) |
monisha
Messages: 8 Registered: February 2008
|
Junior Member |
|
|
By log file you mean the flat file through which I am getting the data. Please let me know if this okay.
I am not able to upload the file when I am trying to upload the file it says this page cannot be displayed
|
|
|
|
|
|
|
|
|
|
|
Re: Special Language Character [message #302080 is a reply to message #302042] |
Sat, 23 February 2008 01:15 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68678 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Everything is correct in this log.
Could you post a line of data that is not correctly loaded and the select on the table for this line what you expected for this line and row.
Regards
Michel
|
|
|