Home » RDBMS Server » Server Utilities » Sqlloader issue (Oracle 10g solaris)
Sqlloader issue [message #538470] Fri, 06 January 2012 06:21 Go to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Hi,

When I load the data into the table, a junk character also inserted into the table as below.

APP_ID
---------

♀APP00111
APP00111
APP00111
APP00111


But the raw data is in wordpad file and does not have any junk character. Pls help me how to avoid this junk character?

APP00111 |DB2       |HOST2    |06-JAN-12 12:05   |GLUE                     |API_MONITOR                        |PACKAGE BODY                  |INVALID
APP00111 |DB2       |HOST2    |06-JAN-12 12:05   |SADMIN                   |NIBR                               |PROCEDURE                     |INVALID
APP00111 |DB2       |HOST2    |06-JAN-12 12:05   |PREEIMLOAD2              |DMD_6318_VIEW_1                    |VIEW                          |INVALID
APP00111 |DB2       |HOST2    |06-JAN-12 12:05   |PREEIMLOAD2              |DMD_6900                           |PACKAGE BODY                  |INVALID
 

[Updated on: Fri, 06 January 2012 06:32]

Report message to a moderator

Re: Sqlloader issue [message #538472 is a reply to message #538470] Fri, 06 January 2012 06:37 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I bet this is an Unicode text file.
Open it with an hexa editor and post the beginning.

Regards
Michel
Re: Sqlloader issue [message #538496 is a reply to message #538472] Fri, 06 January 2012 10:12 Go to previous messageGo to next message
Barbara Boehmer
Messages: 7938
Registered: November 2002
Location: California, USA
Senior Member
You can trim the character off in your control file:

your_column "ltrim (:your_column, '♀')"
Re: Sqlloader issue [message #538505 is a reply to message #538496] Fri, 06 January 2012 10:42 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
WHEN OTHERS THEN NULL; Smile

Regards
Michel

[Updated on: Fri, 06 January 2012 10:55]

Report message to a moderator

Re: Sqlloader issue [message #538814 is a reply to message #538496] Mon, 09 January 2012 10:18 Go to previous messageGo to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Quote:
your_column "ltrim (:your_column, '♀')"


I chaged the control file as you said.

But after saving the file, the line is coming like this below. So still the problem exist. pls let me know what should I do next

APP_ID "LTRIM (:APP_ID, '?')",


[Updated on: Mon, 09 January 2012 10:20]

Report message to a moderator

Re: Sqlloader issue [message #538817 is a reply to message #538814] Mon, 09 January 2012 10:23 Go to previous messageGo to next message
Michel Cadot
Messages: 58638
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read my first post.

Regards
Michel
Re: Sqlloader issue [message #538819 is a reply to message #538817] Mon, 09 January 2012 10:54 Go to previous message
Barbara Boehmer
Messages: 7938
Registered: November 2002
Location: California, USA
Senior Member
Apparently your database character set does not support your input character set. So, you have to either use some sort of editor to remove the offending characters, which may just be the first character of the file, due to being saved as unicode, before loading or remove the converted characters after loading. Please see the section of the online documentation in the link below for details.

http://docs.oracle.com/cd/E11882_01/server.112/e22490/ldr_control_file.htm#SUTIL1084
Previous Topic: import problem
Next Topic: Issue while using sequence in sqlloader
Goto Forum:
  


Current Time: Thu Jul 31 15:27:00 CDT 2014

Total time taken to generate the page: 0.08710 seconds