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

Home -> Community -> Usenet -> c.d.o.misc -> Re: using sqlldr - help <gg>

Re: using sqlldr - help <gg>

From: <drippel_at_perspect.com>
Date: 1997/09/05
Message-ID: <34126d1f.36878869@news.erols.com>#1/1

Sounds like you will need to do some shell scripting.

  1. create a generic CTL control file with a token for the infile name
  2. use sed to replace the token with the actual file name and pipe to a new control file
  3. fire up sql loader with the new control file

On Fri, 05 Sep 1997 17:25:15 +0200, Gerard Le Comte <sns_at_sns.fr> wrote:

>I want to use a CTL file using 2 or more INFILEs.
> This INFILE are generated dynamicaly, so they cannot
> be a unique file.
>
> How can I do that in my CTL file ???
>
> Thanks for help in advance.
>
> G Le Comte.
>
>ps : please reply to answer.
Received on Fri Sep 05 1997 - 00:00:00 CDT

Original text of this message

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