Use Heterogeneous Services to access non-Oracle data
June 3, 2005[From Builder.com]
Oracle's Heterogeneous Services (HS) allows users to access data stored outside Oracle as if the data were in a local Oracle table. It can be intimidating setting up HS in Oracle SQL*Net, so I'll provide some simple examples.
It's best to start from the data and work your way towards actual configuration. For the example in Listing A (which is for Oracle 9i on Windows), I'll start with a list of Australian capitals and their geographical coordinates in a file called capital.txt in an empty folder.
The article continues at http://builder.com.com/5100-6388_14-5725974.html?tag=sc