Loading 2 tables from a .ctl (control) file

[EvansEd]

I wanted to load two different data files, one after the other into the same table. Can I do this? (see below)
If not, what would be the correct structure to load two files?

OPTIONS ( SILENT=(FEEDBACK) )
LOAD DATA
INFILE "$DATFILE"
BADFILE "$BADFILE"
INFILE "$DATFILE2"
BADFILE "$BADFILE2"
INTO TABLE iwork TRUNCATE
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' TRAILING NULLCOLS
(ACCT char
,DBT_MEMO_NBR char
,DSTRBTR_NM char
)

 

[karluk]

What you're doing should work. It looks very similar to the example in the Oracle Utilities manual that shows how to specify multiple data files in a single load.

 

[wwwian]

Except....

You are TRUNCATING INTO the table twice !!