Does Oracle have an equivalent to sybase proxy tables?
428138Aug 23 2004 — edited Aug 23 2004I am a newbie to this area of Oracle.
Sybase has a product called omni-connect that allows you to create a table that is a proxy to a table on another server.
Using a number of proxy tables and a join, you can create a read only view across multiple database servers.
This allows you to view data across multiple systems without re-writing your application to be enterprise aware.
Is there a similar facility in Oracle 9i or 10g.
Paul