Home » RDBMS Server » Server Utilities » special character while loading (oracle 11gr2 sun solaris 10.5)
special character while loading [message #596250] Thu, 19 September 2013 08:45 Go to next message
guddu_12
Messages: 166
Registered: April 2012
Location: UK
Senior Member
Hi All,

I have a file which i am loading , the last column is being loaded with special character which looks like sqare shape character for all the rows.
How can i prevent it to load as it is not present in the file

data in file
 
Department|2|Tranport for London|Rail & Underground|ER|ER|ER|ER|ER|ER|555555555|Owner 8|8


the data once loaded for the last column on which is for above example last column value 8 will be loaded with 8 and square share character.

Any clue

icon10.gif  Re: special character while loading [message #596262 is a reply to message #596250] Thu, 19 September 2013 10:37 Go to previous messageGo to next message
Michel Cadot
Messages: 57616
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Your file was generated by a Windows (or some big OS) and you do it in Unix.
You have to either transfer your file in ASCII mode or use a program like "dos2unix" to convert the end of line characters.

[Updated on: Thu, 19 September 2013 10:37]

Report message to a moderator

Re: special character while loading [message #596264 is a reply to message #596262] Thu, 19 September 2013 10:51 Go to previous messageGo to next message
guddu_12
Messages: 166
Registered: April 2012
Location: UK
Senior Member
Yes that is the case , but my user will always generate file in window and my which will be seen in unix and loader will read. how can i set the property so that i don't have to convert it
Re: special character while loading [message #596265 is a reply to message #596262] Thu, 19 September 2013 10:58 Go to previous messageGo to next message
cookiemonster
Messages: 10573
Registered: September 2008
Location: Rainy Manchester
Senior Member
Michel Cadot wrote on Thu, 19 September 2013 16:37

transfer your file in ASCII mode

Re: special character while loading [message #596641 is a reply to message #596250] Wed, 25 September 2013 06:14 Go to previous message
guddu_12
Messages: 166
Registered: April 2012
Location: UK
Senior Member
Hi ,

sorry for late replying,

The solution dos2unix works very well, but i have implemented it differently, the system which produce file had [CR/LF] for end of line which i have changed to just [LF], so i don't have to convert the file.

Many thanks for your suggestion , it was also good to know those.
Previous Topic: import
Next Topic: How to get parent table column reference and put in child table while loding data using sql loader
Goto Forum:
  


Current Time: Mon Apr 21 05:04:03 CDT 2014

Total time taken to generate the page: 0.08506 seconds