Very Computer

        Persevere in setting up your db links and only have the data in one
place.  It will simplify maintenance and avoid the problem of
inconsistent data.

Original Message dated 4/10/00, 10:03:16 PM

Re: Newbie: Need Help in sharing common data tables across schemas:

Hello.
Will this idea(s) work?
I will have a schema called common where I have various reusable data
tables that are used by various other schemas for foreign keys and
various other things. I think that I need to construct a db link to
provide access
from the other schema to the common schema however I am having
problems setting that up and also the permissions.
Is this the best method for doing this type of data reuse or should I
be duplicating and pushing out the data to each schema. What is the
preferred way to do this and what are the pros/cons?
STeve

We have done something like this,  we used private synonyms.
you could use public sysnonyms so by default every one could access them.
Tom

  Hello.
  Will this idea(s) work?

  I will have a schema called common where I have various reusable data tables that are used by various other schemas for foreign keys and various other things. I think that I need to construct a db link to provide access
  from the other schema to the common schema however I am having problems setting that up and also the permissions.

  Is this the best method for doing this type of data reuse or should I be duplicating and pushing out the data to each schema. What is the preferred way to do this and what are the pros/cons?

  STeve

If so, use synonyms.

Another idea is to use schema-name-prefixes.

e.g. DEMO could use SCOTT.EMP

SCOTT could use DEMO.ITEM and so on.

The owner of the tables needs to GRANT <object permissions> to <other
schemas / users>.

Until version 8.1.6, schema = user.

Ignore Db Links unless your schemas are on different databases (thus you
need to transfer data / read data across different respectice instances
( a shared memory area and a set of background OS processes).

Source the Oracle manuals and research the topics listed above.

David P.

Oracle Certified DBA.

=======================================================================