RE: sqlldr from remote machine

  • From: Dustin Hayden <DHayden@xxxxxxxxxx>
  • To: Martijn Bos <maboc@xxxxxxxx>
  • Date: Thu, 12 Jan 2012 12:40:03 +0000

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.


-----Original Message-----
From: Martijn Bos [mailto:maboc@xxxxxxxx] 
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


Other related posts: