Home » RDBMS Server » Server Utilities » Sqlloader issue (Oracle 10g solaris)
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 #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
|
|
|
|
|
Goto Forum:
Current Time: Mon Feb 24 08:23:43 CST 2025
|