Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

sql loader advice? needed

Status
Not open for further replies.

Keendev

Technical User
Jan 23, 2006
106
PH
Hi,

Need some help. Would it be possible if I do this?
I have this project website, about uploading
csv files. The database resides on diff server and application server is another machine.
Website is on Coldfusion platform and using Oracle database.

From the website, people will upload csv files, and files will be saved inside application web server.
Im planning to use sql loader to read those csv files and be saved to the dtabase.

Question: even if they are on different server can the database server find/read those csv files
that is on the application server and be save to DB by using SQL loader from Oracle??

1. path of csv files inside application server:
c:\inetpub\
2.I will create batch file to run and perform insert into table
c:\inetpub\ --> if executed will read those csv files


Is this possible ? even if batch file and ctl files and CSV files is inside the application server?
Need a tip and advice for this before I continue.... I have limited knowledge regarding server config etc....
need a tip =)

thanks in advance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top