Re: sqlldr from remote machine

From: Martijn Bos <maboc_at_maboc.nl>
Date: Thu, 12 Jan 2012 13:54:36 +0100
Message-ID: <20120112125436.GB31887_at_app01.bos>

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>_at_<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>_at_<host> <script>     or
    b - start the sqlldr on the server by ssh (ssh <user>_at_<host> <sqlldr command>

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

best regards,
Martijn

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

Received on Thu Jan 12 2012 - 06:54:36 CST