Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> 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 ZappaReceived on Fri Sep 10 1999 - 01:21:26 CDT
![]() |
![]() |