Re: Sharing tables from multiple instances ?

In article <7r5jli$sh5_at_romeo.logica.co.uk>,   "Edwin Hartog" <hartoge_at_logica.com> wrote:
> Many applications get data from a large table (ZIP code). Several
instances
> are copied from a production dump, including this table, for parallel
> developments. Is it possible to have one copy of the ZIP code table,
which
> can be accessed from all the different instances ?
>
> TIA
> ----
>
> Edwin H. Hartog
>

You can access remote tables in Oracle by using database links if you have the distributed option. You just add the link name to the table name with the '@' symbol as table_name_at_link. Better yet is to create a local synonym that contains the link to the remote object. See the create database link and create synonym commands in the SQL manual. We do this rather extensively accross two platforms running differenct OS's.

Another option is to use replication to make and maintain read only copies of the table in the remote instances. This allows avoiding some of the performance issues that can occur with distributed queries. I think basic replication is now included with the rdbms (at least with the distributed option). Advanced replication, which is probably still a purchased option, would allow you to set up multiple copies of the table and have Oracle coordinate the updates to keep all versions in sync.

You can have multiple instances of Oracle share one database, set of physical files and all contained objects, using the Parallel Server Option. This is a another separate purchased option. We also use this option.

Check with your Oracle representative for what is included with your edition of Oracle, regular or Enterprise. --
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Sep 08 1999 - 08:23:48 CDT