Re: [NEWBIE] SQLLOADER - Load from multiple files

To qualify my post - I consider myself a programming "newbie" but am Oracle 8i certified & have 5 years experience using oracle 7.3.4 & 8i. I'm working on a similar project and had the same question. I'm fortunate that I only have to deal with one file at runtime, so I'm considering forcing the output from the other database to consistently use the same file name, or perhaps copy it to an archive & then rename it (to the consistent name in the control file) with a batch file that would also call SQLLoader. I'm still in the conceptual / design stages though...

Regards,
db

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1091758948.416507_at_yasure...
> Emanuele wrote:
> > Hi,
> > i've to load data from multiple file
> > (eg.
> > data01.dat
> > data02.dat
> > data03.dat
> > data04.dat
> > )
> >
> > but i can now these file's name only in runtime, when i launch the
> > sqlloader command. So I cannot specify them on controlfile.
> >
> > How it works with sqlloader?
> >
> > Thx!!
>
> Not well unless you use Perl or another scripting language.
>
> --
> Daniel A. Morgan
> University of Washington
> damorgan_at_x.washington.edu
> (replace 'x' with 'u' to respond)
>
Received on Fri Aug 13 2004 - 02:04:55 CDT