Re: SQL Loader - Alternative Option??

From: <Alain.Beauchamp_at_gmail.com>
Date: Sat, 07 Jul 2007 00:33:51 -0000
Message-ID: <1183768431.595458.214110@r34g2000hsd.googlegroups.com>

On 6 juil, 16:39, 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

Another option are using the Oracle Heterogeneous Services. http://www.csee.umbc.edu/help/oracle8/server.815/a67784/hs_ch6.htm

Regards. Received on Fri Jul 06 2007 - 19:33:51 CDT