RE: sqlldr from remote machine
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 12 Jan 2012 16:12:43 +0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Dustin Hayden
Sent: Thursday, January 12, 2012 7:40 AM
To: Martijn Bos
Cc: oracle-l@xxxxxxxxxxxxx
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@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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
