Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: multiple infiles into a same table/record

Re: multiple infiles into a same table/record

From: Noel <tomekb_at_softman.pl>
Date: Fri, 28 May 2004 10:06:45 +0200
Message-ID: <c96rth$5up$1@inews.gazeta.pl>

> cant SQL Loader do this directly? coz im trying to load data from 2
> files into 1 staging table and then read data from the staging table,
> do some more validations and put it into another table.Any idea if SQL
> Loader can do this?

Look at the APPEND clause in control file. Trigger on stagging table can do rest of job.

--
TomekB
Received on Fri May 28 2004 - 03:06:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US