Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL*Loader Delimited Problem
"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message
news:asf86k$q5r1a$1_at_ID-127142.news.dfncis.de...
> Hi,
>
> Jonathan, you can load all fields into table1 firstly using FILLER field.
> Something like this:
>
> load data
> into table table1
> (col1,
> col2,
> skip_t2_col1 filler,
> skip_t2_col2 filler,
> col3)
>
> And now then:
>
> into table table2
> (skip_t1_col1 filler position(1),
> skip_t1_col2 filler,
> skip_t1_col3 filler,
> col1,
> col2)
>
> This is the main idea above. Possibly I missed some details and you have
to
> invistigate it a bit.
> Hope this helps.
>
> Regards,
> --
> Roman Mirzaitov
> Brainbench MVP for Oracle Administration
> www.brainbench.com
Thanks a lot Roman, all the stuff was there it takes real brains to see ouw to put it together.
Jonathan Received on Mon Dec 02 2002 - 04:21:23 CST