Hi


We are using 9i external tables for reading data from the files.
The files are on the same machine on which the oracle9i database server is installed.


The files are actually uploaded & reside originally on a different machine where our app server is installed.

Currently we copy all the files into teh machine where orcle 9i databse server is installed & then use external tables to read the same.

What i would like to know is that is it possible to read files for external tables over the network

If yes can some one give an example


Rgrds