OraFAQ Forum: Server Utilities » SQLLDR bad file due to special characters

Home » RDBMS Server » Server Utilities » SQLLDR bad file due to special characters

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

SQLLDR bad file due to special characters [message #218571]

Thu, 08 February 2007 13:20

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

Report message to a moderator