RE: sqlldr from remote machine

Define the nfs mounted sqlldr input file as an External Table then the client 
can connect and just select from the external table as part of an insert/select 
statement to load the target table.

If you really cannot install the sqlldr utility as part of the client install 
then the above should be an option to consider.


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Dustin Hayden
Sent: Thursday, January 12, 2012 7:40 AM
To: Martijn Bos
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: sqlldr from remote machine

I can nfs mount the data on the server.
What I really need to know is how to call sqlldr from a scrip on the client 
machine.


-----Original Message-----
From: Martijn Bos [mailto:maboc@xxxxxxxx] 
Sent: Thursday, January 12, 2012 7:35 AM
To: Dustin Hayden
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: sqlldr from remote machine

I think it's not possible, unless the file is made available via nfs or so.
I think so because afaik you can't supply a data-input-file to sqlldr with some 
sort of network identifier. So to sqlldr the file data-input-file should exist 
on the same machine where sqlldr exists. (With nfs you can make that happen)

Is it a possibility to scp the data to the server? Then your script can handle 
everything locally on the server.

Best Regards,

Martijn


--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l

Other related posts: