Home » RDBMS Server » Server Utilities » HOW TO PROCESS ASCII CHARACTER 29 WHILE LOADING DATA WITH SQL LOADER (Oracle 9i, Windows)
HOW TO PROCESS ASCII CHARACTER 29 WHILE LOADING DATA WITH SQL LOADER [message #466661] Tue, 20 July 2010 07:59 Go to next message
varunendra
Messages: 4
Registered: July 2010
Location: India
Junior Member
i have to upload a file in database, the column seperator is ASCII CHARACTER 29, i dont know how to specify that in loader file?

how to write this - fields terminated by ' ' in sql file, which i am calling from a batch file.

i have attached the text file which i am trying to upload, here field seperator is ASCII CHARACTER 29 and record seperator is NEW LINE CHARACTER.
Re: HOW TO PROCESS ASCII CHARACTER 29 WHILE LOADING DATA WITH SQL LOADER [message #466664 is a reply to message #466661] Tue, 20 July 2010 08:12 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
You can specify the hexadecimal code.

Try :

fields terminated by X'1D'

Re: HOW TO PROCESS ASCII CHARACTER 29 WHILE LOADING DATA WITH SQL LOADER [message #466668 is a reply to message #466664] Tue, 20 July 2010 08:42 Go to previous messageGo to next message
varunendra
Messages: 4
Registered: July 2010
Location: India
Junior Member
Thanks THOMAS, it worked.

Can you please eloborate the concept behind putting the hexadecimal code.
Re: HOW TO PROCESS ASCII CHARACTER 29 WHILE LOADING DATA WITH SQL LOADER [message #466672 is a reply to message #466668] Tue, 20 July 2010 09:00 Go to previous message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Not sure what I can "elaborate" there. The X tells SQL*Loader that the following expression should be interpreted as hexadecimal ASCII character.

There is more info in the FAQ.
Previous Topic: Snapshot error during export
Next Topic: EXP vs IMPDP interrogating dump file
Goto Forum:
  


Current Time: Thu Mar 28 07:14:36 CDT 2024