SQL Loader ... Data file at http location [message #234264] |
Mon, 30 April 2007 11:24 |
rmane
Messages: 1 Registered: April 2007 Location: Atlanta
|
Junior Member |
|
|
Hi,
I am using sqlloader to load the data file into my oracle tables.
It works fine if the data file is at some local dir.
Ex:
load data
infile 'Monthly Gross Adds Last Year.txt'
into table MON_GROSS_ADDS_LAST_YEAR
REPLACE
fields terminated by '\t'
TRAILING NULLCOLS
(VPGM_EOM, DOS_EOM, ARSM_EOM, LOCATION_NAME_EOM, YEAR_MONTH, GROSS_ADDS)
But now are in a situation were the data file is at some remote http location ex. "http://d1uea1m1.edc.cingular.net/sbm/bpmportal/MON_GROSS_ADDS_LAST_YEAR.txt"
Can I modify my script above to include this change in infile location OR Is there an alternate way to do this.
Any help is appreciated.
Thank you,
Rajesh
|
|
|
|