Home » RDBMS Server » Server Utilities » SQLLDR bad file due to special characters
SQLLDR bad file due to special characters [message #218571] Thu, 08 February 2007 13:20 Go to next message
manish mendiratta
Messages: 110
Registered: May 2002
Senior Member
Hi All,

I am trying to upload file thru an Sun os cronjob using sqlldr.
This file now contains some special language characters. It send all the records with such characters in bad file. I have to import the bad file from Sun Server to my local machine and upload the data thru Toad sqlldr.
I don't modify the data.
I want to know why it throws error on Sun but gets loaded from windows. I am attaching some excerpts from bad file.
Please suggest.


"960696576","960696831","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","SITA-SOCIETE INTERNATIONALE DE TELECOMMUNICATIONS AERONAUTIQUES"
"1041008640","1041008655","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","MAILFARM"
"1041008656","1041008671","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","CYB-SGMS"
"1041008672","1041008703","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","CYBERLINK INTERNET SERVICES AG"
"1041008704","1041008735","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","WEBFARM"
"1041008736","1041008895","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","CYBERLINK INTERNET SERVICES AG"
"1041117440","1041118207","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","A GLOBAL ISP"
"1041124352","1041124607","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","JAZZ TELECOM S.A"
"1041134336","1041134591","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","JAZZ TELECOM S.A"
"1041136640","1041137407","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","JAZZ TELECOM S.A"
"1041147136","1041147391","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","A GLOBAL ISP"
"1041148928","1041149183","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","A GLOBAL ISP"
"1041149440","1041149695","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","A GLOBAL ISP"
"1041157120","1041157375","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","JAZZ TELECOM S.A"
"1041161216","1041162239","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","JAZZ TELECOM S.A"
"1041162496","1041162527","ES","SPAIN","CATALUņA","BARCELONA","41.383","2.183","INTEGRA"

In my control file ...I AM using feild terminated by "," and enclosed by "

Thanks in advance.
Manish
Re: SQLLDR bad file due to special characters [message #218577 is a reply to message #218571] Thu, 08 February 2007 14:37 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> I want to know why it throws error on Sun but gets loaded from windows
Look into the logfile.
Re: SQLLDR bad file due to special characters [message #221211 is a reply to message #218571] Sun, 25 February 2007 08:42 Go to previous message
vamshi
Messages: 6
Registered: November 2000
Location: Hyderabad
Junior Member

Hello Friend,

In your control file you need to mention like this,

fields terminated by ','
optionally enclosed by '"'

Try this and execute
Previous Topic: Import export utility
Next Topic: can data pump only export/import views also.
Goto Forum:
  


Current Time: Sat Dec 03 06:15:41 CST 2016

Total time taken to generate the page: 0.04929 seconds