RE: sqlldr from remote machine
- From: <rajendra.pande@xxxxxxx>
- To: <maboc@xxxxxxxx>, <DHayden@xxxxxxxxxx>
- Date: Thu, 12 Jan 2012 07:59:42 -0500
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martijn Bos
Sent: Thursday, January 12, 2012 7:55 AM
To: Dustin Hayden
Cc: oracle-l@xxxxxxxxxxxxx
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>@<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
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
