RE: sqlldr from remote machine
- From: <rajendra.pande@xxxxxxx>
- To: <maboc@xxxxxxxx>, <DHayden@xxxxxxxxxx>
- Date: Thu, 12 Jan 2012 07:40:40 -0500
I am guessing that unless a complicated set of solution some remote
(rsh/ssh) commands are put in place, I too believe this is not possible
.
But then what is the rationale for doing so. What is the driver for
requesting a solution like this where an easier solution can easily be
put in place
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Martijn Bos
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
--
//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:
