Re: SQL Loader - Alternative Option??

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 06 Jul 2007 15:51:20 -0700
Message-ID: <1183762280.531661.15210@w3g2000hsg.googlegroups.com>

On Jul 6, 4:39 pm, fd96..._at_yahoo.com wrote:
> Hi,
>
> Is there any other option of loading file into a database apart from
> SQL loader and tools like informatica?
>
> We have a set up with 2 boxes, with a limitation that one is an app
> server, other the database. And the requirement is we load the files
> from the app server box to the oracle db.
>
> One of the options is create insert scripts using unix shell scripting
> and load the file into the database using oracle instant client for
> 10g. Is there any other option???
>
> Please let me know.
>
> Thanks

External table processing depending on your oracle version may be a possibility.

C or C++ programs ( or java or perl even ) that process flat files is another possibility. Received on Fri Jul 06 2007 - 17:51:20 CDT