RE: sqlldr from remote machine
Date: Thu, 12 Jan 2012 16:12:43 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415937DD6110F55_at_GVW1337EXC.americas.hpqcorp.net>
Define the nfs mounted sqlldr input file as an External Table then the client can connect and just select from the external table as part of an insert/select statement to load the target table.
If you really cannot install the sqlldr utility as part of the client install then the above should be an option to consider.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Dustin Hayden
Sent: Thursday, January 12, 2012 7:40 AM
To: Martijn Bos
Cc: oracle-l_at_freelists.org
Subject: RE: sqlldr from remote machine
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
--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jan 12 2012 - 10:12:43 CST