Home » RDBMS Server » Server Utilities » sqlldr caused error with 00h symbol in source file
sqlldr caused error with 00h symbol in source file [message #475140] Mon, 13 September 2010 05:02 Go to next message
dimas_xp
Messages: 4
Registered: September 2010
Location: MSK
Junior Member
I am loading data file, and in some positions there is symbol 00h. This is caused error of sqlldr and uploading stops.
How I can replace this symbol or do something else to fix this error.

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475142 is a reply to message #475140] Mon, 13 September 2010 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
As far as I know, you have to do it outside SQL*Loader as Oracle is written in C and for C a '\0' character is the end of a string.

Regards
Michel

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475147 is a reply to message #475142] Mon, 13 September 2010 06:10 Go to previous messageGo to next message
dimas_xp
Messages: 4
Registered: September 2010
Location: MSK
Junior Member
it's not a approach in my case. Source file shouldn't be changed. Is there any other ideas?

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475156 is a reply to message #475147] Mon, 13 September 2010 06:33 Go to previous messageGo to next message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
"This can't be done in SQL*Loader"
"Yes, but I want to do it in SQL*Loader"
"But this can't be done"
"Yes but I want to do it"
...

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475157 is a reply to message #475156] Mon, 13 September 2010 06:34 Go to previous messageGo to next message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Source file shouldn't be changed.

Copy the source file into another one, modify and load the copy.

Regards
Michel

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475158 is a reply to message #475157] Mon, 13 September 2010 06:40 Go to previous messageGo to next message
dimas_xp
Messages: 4
Registered: September 2010
Location: MSK
Junior Member
Do you have any perl script to replace this symbol?

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475159 is a reply to message #475158] Mon, 13 September 2010 06:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68771
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
No. Can't you write such one?

Regards
Michel

Report message to a moderator

Re: sqlldr caused error with 00h symbol in source file [message #475172 is a reply to message #475159] Mon, 13 September 2010 07:16 Go to previous message
dimas_xp
Messages: 4
Registered: September 2010
Location: MSK
Junior Member
I can try.

Report message to a moderator

Previous Topic: EXPORT COMMAND IS NOT WORKING IN 11G THAT WOULD IN 8i
Next Topic: EXP, EXPDP, IMP & IMPDP
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Nov 26 22:42:54 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.