Sorry if I've hit the wrong group, or if this question has been asked & answered. I couldn't find it in the archives.
My company has a substantial investment in Oracle (one that I'd like to reduce). Mostly Oracle 8.1.7 and lower. There are literally dozens of applications accessing the databases, so porting a complete Oracle databse to PostgreSQL is not in the cards.
I'd like to set up a pgsql database that has server-based links back to an Oracle db. Not replication, but a live link (the data I'm looking for can change rapidly). The pgsql client would see it as a native pgsql table, but the pgsql server would submit the query to Oracle in real-time. Basically, a view of the Oracle data.
At this point, we're not looking to insert/update/delete any Oracle data, nor run stored procs/functions. Just a dang SELECT.
Any ideas?
tia,
Ted.