Re: use of schemas

From: Mike Burden <michael.burden_at_capgemini.co.uk>
Date: Mon, 08 Mar 1999 16:56:51 +0000
Message-ID: <36E40153.9088A9DA@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 - 10:56:51 CST