Home » RDBMS Server » Server Utilities » Special Language Character
Special Language Character [message #301491] Wed, 20 February 2008 19:02 Go to next message
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 #301552 is a reply to message #301491] Thu, 21 February 2008 00:48 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Your control file (at least the one you posted) is not valid.
It is hard to tell what is wrong when you have not the table description.

With what you posted, we have to assume (if control file and data are correct) that you only want to load the first column (unique_identifier) and it is a varchar2.

You have to post your log file, if you want more help.

But before, please read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter) and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

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 messageGo to next message
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.
  • Attachment: EPH_STAGE.ctl
    (Size: 4.07KB, Downloaded 1061 times)

Report message to a moderator

Re: Special Language Character [message #302006 is a reply to message #302001] Fri, 22 February 2008 12:10 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
You have to post your log file, if you want more help.

Regards
Michel

[Updated on: Fri, 22 February 2008 12:10]

Report message to a moderator

Re: Special Language Character [message #302009 is a reply to message #302006] Fri, 22 February 2008 12:31 Go to previous messageGo to next message
monisha
Messages: 8
Registered: February 2008
Junior Member
No Message Body

Report message to a moderator

Re: Special Language Character [message #302010 is a reply to message #302009] Fri, 22 February 2008 12:34 Go to previous messageGo to next message
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

Report message to a moderator

Re: Special Language Character [message #302013 is a reply to message #302010] Fri, 22 February 2008 12:50 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I mean the log file generated by sql*loader.

Regards
Michel

Report message to a moderator

Re: Special Language Character [message #302022 is a reply to message #302013] Fri, 22 February 2008 13:29 Go to previous messageGo to next message
monisha
Messages: 8
Registered: February 2008
Junior Member
I am sending you the log file

Report message to a moderator

Re: Special Language Character [message #302026 is a reply to message #302022] Fri, 22 February 2008 13:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is your script log file not sql*loader one.

Regards
Michel

Report message to a moderator

Re: Special Language Character [message #302033 is a reply to message #302026] Fri, 22 February 2008 14:18 Go to previous messageGo to next message
monisha
Messages: 8
Registered: February 2008
Junior Member
I dont have sql loader log file. No idea about it

Report message to a moderator

Re: Special Language Character [message #302035 is a reply to message #302033] Fri, 22 February 2008 14:22 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So we can't know what happened.

Regards
Michel

Report message to a moderator

Re: Special Language Character [message #302038 is a reply to message #302035] Fri, 22 February 2008 14:29 Go to previous messageGo to next message
monisha
Messages: 8
Registered: February 2008
Junior Member
do you have any idea where can I get that sql loader log file.
will that file be genereated or not.

Report message to a moderator

Re: Special Language Character [message #302039 is a reply to message #302038] Fri, 22 February 2008 14:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68653
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to analyze your script to know what command is used to launch sql*loader and where its output goes.

Regards
Michel

Report message to a moderator

Re: Special Language Character [message #302042 is a reply to message #302039] Fri, 22 February 2008 15:07 Go to previous messageGo to next message
monisha
Messages: 8
Registered: February 2008
Junior Member
I am sending you the file
see if it is okay

Report message to a moderator

Re: Special Language Character [message #302080 is a reply to message #302042] Sat, 23 February 2008 01:15 Go to previous message
Michel Cadot
Messages: 68653
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

Report message to a moderator

Previous Topic: sqlldr log file issue
Next Topic: SQL LOADER -Ora error-01858 and 01843
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 05:12:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.