Use Heterogeneous Services to access non-Oracle data

June 3, 2005

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