SQL*LOADER, using multiple intos for the same table

Hi,

I have a file of data for a table without enough columns. So, i have to create another row to completely import the data for one row. I know the logical step is to create more columns but I cannot for other reasons. So, here is what I am doing:

append
into table x

      column a  sequence (max,1)
      column b   pos 1:3
      column c   pos 4:6
      column d   pos 7:9
into table x
      column  a sequence (max,2)
      column  b pos 13:14,
      column c pos  15:16

I am trying to grab data in another part of the record and insert it into the same column as the initial insert. The problem is column a is the primary key and I keep getting unique constraint errors. So, I am trying to figure out is there an option that allows the first into to completely finish its inserts and then attacks the second into statement OR do I create a sequence and use the nextval attribute for both INTO's. Please help, I am stuck. Thx. Received on Fri Sep 28 2007 - 21:30:38 CDT