Home » RDBMS Server » Server Utilities » SQL Loader ... Data file at http location
SQL Loader ... Data file at http location [message #234264] Mon, 30 April 2007 11:24 Go to next message
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
Re: SQL Loader ... Data file at http location [message #234265 is a reply to message #234264] Mon, 30 April 2007 11:28 Go to previous message
Michel Cadot
Messages: 64153
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to firt ftp your file on local site. Oracle SQL*Loader does not understand your http location.

Regards
Michel
Previous Topic: Different log file name in the Control file of SQL Loader
Next Topic: SQL * Loader problem
Goto Forum:
  


Current Time: Sun Dec 11 02:27:34 CST 2016

Total time taken to generate the page: 0.11542 seconds