Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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
![]() |
![]() |