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

The Network for Technology Professionals



Legal Notices, Licensing, Permissions, Privacy Policy.
Advertise | Newsletters | E-mail Offers