Re: SQL*Loader and Stream Record Format - infodev_us_at_oracle.com solution
Date: Fri, 30 Dec 2005 10:39:16 -0500
Message-ID: <op.s2lsfqbroireee_at_mobileoran>
On Tue, 27 Dec 2005 12:29:59 -0500, <infodev_us_at_oracle.com> wrote:
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
On Thu, 29 Dec 2005 19:48:22 -0500, IANAL_VISTA <IANAL_Vista_at_hotmail.com> wrote:
> "oran johnson" <mobileoran_at_optonline.net> wrote in
> news:op.s2et13fwoireee_at_mobileoran:
>
> complaints WRT to previous responses & responders
>
> [...snip...]
>
> biting the hand that feeds you is a great way to starve.
>
> Enjoy the resounding silence to your problems.
>
> P.S.
> You can place within the INFILE anything you desire.
> Whether or not it is acceptable, is up to you to determine.
>
>
> HAND!
-- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/Received on Fri Dec 30 2005 - 16:39:16 CET