Re: sqlldr from remote machine
From: Martijn Bos <maboc_at_maboc.nl>
Date: Thu, 12 Jan 2012 13:35:17 +0100
Message-ID: <20120112123517.GA31887_at_app01.bos>
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)
Date: Thu, 12 Jan 2012 13:35:17 +0100
Message-ID: <20120112123517.GA31887_at_app01.bos>
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-lReceived on Thu Jan 12 2012 - 06:35:17 CST