Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Loader - Alternative Option??

Re: SQL Loader - Alternative Option??

From: HansF <fuzzy.greybeard_at_gmail.com>
Date: Fri, 06 Jul 2007 12:13:28 -0700
Message-ID: <1183749208.453279.215980@m36g2000hse.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US