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 ?

Put it in one instance. Create database links to that instance from all the other instances. In the "target" instances, instead of the table create a synonym with its name equivalent to the table qualified by the link name:

CREATE DATABASE LINK ORIG
CONNECT TO user IDENTIFIED BY pswd
USING 'orig_SID';

CREATE SYNONYM ZIPCODE_TBL FOR
ZIPCODE_TBL_at_ORIG; Now this will work in any of the instances:

SELECT ZIPCODE FROM ZIPCODE_TBL WHERE ...

Paul de Anguera | "You can't write a chord ugly enough to say
Reply to:       | what you want to say sometimes, so you have to
deanguer@       | rely on a giraffe filled with whipped cream."
quidnunc.net    | - Frank Zappa