Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader - Alternative Option??
On Jul 6, 12:54 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
Well ...
You could write your own equivalent to SQL Loader;
You could create upload PERL scripts;
You could (legally) install the SQL*Loader client on the App server
box and use that.
Received on Fri Jul 06 2007 - 14:13:28 CDT