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.
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.