Home » RDBMS Server » Server Utilities » Bad files when using multiple input files with sqlldr
Bad files when using multiple input files with sqlldr [message #304597] Wed, 05 March 2008 15:30 Go to next message
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!
Re: Bad files when using multiple input files with sqlldr [message #304604 is a reply to message #304597] Wed, 05 March 2008 16:14 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8620
Registered: November 2002
Location: California, USA
Senior Member
http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/ldr_control_file.htm#sthref883
Re: Bad files when using multiple input files with sqlldr [message #304608 is a reply to message #304597] Wed, 05 March 2008 16:42 Go to previous message
tmcallister
Messages: 107
Registered: December 2007
Senior Member
Exactly the information I needed. Thanks!
Previous Topic: User Schema Migration
Next Topic: SQL Loader: Sort the datafile
Goto Forum:
  


Current Time: Fri Dec 02 16:57:48 CST 2016

Total time taken to generate the page: 0.21156 seconds