RE: sqlldr from remote machine

From: Dustin Hayden <DHayden_at_sprich.com>
Date: Thu, 12 Jan 2012 12:40:03 +0000
Message-ID: <ED8913458C966249856499C923CE5C8B18CEB06C_at_prd-dag-01.ad.sprich.com>



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_at_maboc.nl] Sent: Thursday, January 12, 2012 7:35 AM To: Dustin Hayden
Cc: oracle-l_at_freelists.org
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

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jan 12 2012 - 06:40:03 CST

Original text of this message