OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Sqlloader issue (Oracle 10g solaris)

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

Sqlloader issue [message #538470]

Fri, 06 January 2012 06:21

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I bet this is an Unicode text file.
Open it with an hexa editor and post the beginning.

Regards
Michel

Report message to a moderator

Re: Sqlloader issue [message #538496 is a reply to message #538472]

Fri, 06 January 2012 10:12

Barbara Boehmer
Messages: 9101
Registered: November 2002
Location: California, USA

Senior Member

You can trim the character off in your control file:

your_column "ltrim (:your_column, '♀')"

Report message to a moderator

Re: Sqlloader issue [message #538505 is a reply to message #538496]

Fri, 06 January 2012 10:42

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

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

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

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Read my first post.

Regards
Michel

Report message to a moderator

Re: Sqlloader issue [message #538819 is a reply to message #538817]

Mon, 09 January 2012 10:54

Barbara Boehmer
Messages: 9101
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

Report message to a moderator

Previous Topic:	import problem
Next Topic:	Issue while using sequence in sqlloader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 07:05:48 CST 2024