Bad files when using multiple input files with sqlldr [message #304597] |
Wed, 05 March 2008 15:30 |
tmcallister
Messages: 107 Registered: December 2007
|
Senior Member |
|
|
I'm having a problem with sqlldr and multiple inpute files.
I call using:
sqlldr <conn> control=ctl/<ctl>.ctl bad=bad/<bad>.bad log=logs/<log>.log rows=1048576 bindsize=1048576 errors=9999
And the contents of the ctl:
load data
infile "<path>\<data1>"
infile "<path>\<data2>"
infile "<path>\<data3>"
infile "<path>\<data4>"
infile "<path>\<data5>"
infile "<path>\<data6>"
APPEND
into table <table>
fields terminated by '\t'
trailing nullcols
(
<columns>
)
The problem is that the data1 file import errors get loaded into the appropriate directory/name, but all subsequent data files errors get loaded into <dataN>.bad within the ctl directory.
I'd prefer them to all be merged within the 1 provided bad file name/path, but failing that I'd settle for them being seperate files within the BAD file directory, but not the CTL direction.
Now how to specify this? Thanks!
|
|
|
|
|