On Sep 29, 11:25 am, DA Morgan <damor..._at_psoug.org> wrote:
> blackf..._at_verizon.net 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
> damor..._at_x.washington.edu (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -
>
> - Show quoted text -
The problem is I have to insert these values. Basically it's like a
sentence that continues to the next line. I send the first wave
through then another row to insert different data in a few select
columns in the next. It's possible to do this but the problem in my
case is that the primary key is a sequence and eventually it runs into
a constraint error. I was hoping there would be some technical way to
get around this but it sounds like I am going to have to split the ctl
file and run a script to execute them both. It sucks but hey unless
someone knows a way this can work.
Received on Sun Sep 30 2007 - 00:10:59 CDT
