Re: SQL*Loader and Stream Record Format - infodev_us_at_oracle.com solution

Display all headersDate: Tue, 27 Dec 2005 09:29:59 -0800 From: infodev_us_at_oracle.com
Subject: Re: sql loader and internet file access To: oran johnson <mobileoran_at_optonline.net>

Hi Oran,

I don't believe there is a feature like this. The typical workflow in such a case is to drive it through a script that retrieves the file with 'curl' or 'wget' and then calls SQL*Loader.

Thanks,
John

On Dec 27, 2005, at 4:45 AM, oran johnson wrote:

I have recently installed the express edition and loaded my first table. I would like to update this table using sql*loader. After going thur all the online documentation, I can not find any reference to accessing an internet data file. In other words, can I specify something like this: infile
'http://www.something.com/something.txt' in a sql*loader control file.

Regards.
Oran Received on Wed Dec 28 2005 - 15:10:10 CET