For the shared tables you can put public synonyms, as oppose to the
tables which are application specific.
Mike Burden wrote in message <36E40153.9088A9DA_at_capgemini.co.uk>...
>What you really don't want to do is code the schema name in any
application. As long
>as you don't do this then you can have different instances of the
application
>accessing different versions of the table. If you need multiple schemas so
you can
>organize your tables more effectively then access them from a single schema
by using
>synonyms. That way the tables can sit in any schema.
>
>Hope this helps.
>
>Julio Peixoto wrote:
>
>> If you had different applications to be implemented on only one database.
If
>> you had tables to be used by
>> only one application and tables to be shared among them. Would you
implement
>> one schema for each
>> one of the applications or use only one schema for all? Why?
>>
>> *** Posted from RemarQ - http://www.remarq.com - Discussions Start Here
(tm) ***
>
Received on Mon Mar 08 1999 - 20:08:59 CST
