Re: 3000 files with SQL*LOADER

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 2 Jun 2001 09:19:13 +0200
Message-ID: <thh4njpaccca4f@beta-news.demon.nl>

"doel" <doel_at_operamail.com> wrote in message news:9dea384f.0106011955.2fd1d7bf_at_posting.google.com...
> Dear All,
>
> I have problem in uploading flat files into oracle. It is easy when
> there're 5,6 or 7 or .. but I have more than 3000 files in one
> directory.
>
> is there an easy way to do this with SQL*LOADER?
>
> TIA,
> Doel.

sure how about setting up a shell script or a cmd script which will do a for on your files, and call sql*loader for every individual file. Should be dead easy.

Hth,

Sybrand Bakker, Oracle DBA Received on Sat Jun 02 2001 - 02:19:13 CDT