RE: sqlldr from remote machine

From: <rajendra.pande_at_ubs.com>
Date: Thu, 12 Jan 2012 07:59:42 -0500
Message-ID: <D4C8B99EB96F2C42B4E19A3B87664F5E02E81487_at_NSTMC612PEX.ubsamericas.net>

And the next time the load fails for some reason, the person supporting it curses for putting such a complicated (convoluted?) process in place. :)

I am not clear as to what is the "requirement" that you have, to do this.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Martijn Bos Sent: Thursday, January 12, 2012 7:55 AM To: Dustin Hayden
Cc: oracle-l_at_freelists.org
Subject: Re: sqlldr from remote machine

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


Please visit our website at 
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html 
for important disclosures and information about our e-mail 
policies. For your protection, please do not transmit orders 
or instructions by e-mail or include account numbers, Social 
Security numbers, credit card numbers, passwords, or other 
personal information.
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Jan 12 2012 - 06:59:42 CST