Re: SQL*LOADER, using multiple intos for the same table

blackfunk@xxxxxxxxxxx wrote:
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.

How about just not mapping the data you don't want to insert?
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages