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.


Another option is to create an External Table which reads this text file. You can then use any SQL statements you want to read data from the External Table and insert into any table.

HTH,
Brian


--
===================================================================

Brian Peasland
dba@xxxxxxxxxxxxxxxxxxx
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

--
Posted via a free Usenet account from http://www.teranews.com

.

Relevant Pages