Re: sqlldr from remote machine

  • From: Martijn Bos <maboc@xxxxxxxx>
  • To: Dustin Hayden <DHayden@xxxxxxxxxx>
  • Date: Thu, 12 Jan 2012 13:54:36 +0100

On Thu, Jan 12, 2012 at 12:40:03PM +0000, Dustin Hayden wrote:
> 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.

If you are using ssh then you could do something like : 'ssh <user>@<host> 
<command>'
In this command is for instance your sqlldr command, or a script which handles 
the sqlldr stuff.

So I think:
1 - make the data-input-file available to the server by nfs
2 - run the script on the client which 
    a - starts a sqlldr script on the server-side by ssh (ssh <user>@<host> 
<script> 
    or
    b - start the sqlldr on the server by ssh (ssh <user>@<host> <sqlldr 
command>

ahum...you do need to distribute the public key onde to the server then.


best regards,
Martijn


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


Other related posts: