|
|
|
|
|
Re: SqlLoader concatenate on Windows [message #173106 is a reply to message #173102] |
Fri, 19 May 2006 07:59 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Works as intended, as long as you have the file to be properly formatted (as specified in controlfile. It should be followed by blankspace and terminated by linefeed/carriage return).
I used the notepad. Attached is the actual file.
C:\>sqlldr scott/tiger@mutation control=data.ctl
SQL*Loader: Release 10.2.0.1.0 - Production on Fri May 19 08:57:38 2006
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Commit point reached - logical record count 2
C:\>sqlplus -s scott/tiger@mutation
select * from datatable;
COL1 COL2 COL3 COL4
---- ---- ---- ----
aaa aa aaaa aa
bb bbbb b bb
exit
-
Attachment: data.data
(Size: 0.04KB, Downloaded 1157 times)
[Updated on: Fri, 19 May 2006 07:59] Report message to a moderator
|
|
|
|
Re: SqlLoader concatenate on Windows [message #173125 is a reply to message #173112] |
Fri, 19 May 2006 08:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/42800.jpg) |
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
I still cannot reproduce you case.
A proper linefeed/carraige return ***will*** have whitespace as terminator. This time, i literally opened notepad (and in vi, if that matters) and Typed those entries line-by-line and Sqlldr did the job as expected.
If you cannot fix the format, convert it.
With simple scripting like this, a terminator you want and use it inside controlfile.
oracle@mutation#cat data.data | awk '{print $1","}' > data1.data
oracle@mutation#cat data1.data
aaa,
aa,
aaaa,
aa,
bb,
bbbb,
b,
bb,
|
|
|
|
|
|
|
|