Re: Oracle Schema's

From: Rich Woods <rwoods01_at_interserv.com>
Date: 1996/06/10
Message-ID: <4pfrp2$vi_at_lal.interserv.net>#1/1

Kristiaan Boschman <Kristiaan.Boschman_at_ping.be> wrote:

>Is it recommended to use schema's for differnt business areas or is it
>better to use one owner (or very) few owners for the whole database ?

>I assume in the latter case you have to create a lot of synonyms ?

My recommendation would be to use separate schemas. It becomes much easier to backup (Export) and administer (security, size, relocate) the application database.

Rich Woods
Technical Field Support Specialist, Oracle Corporation, USA The above statements and opinions are my own and do not necessarily represent those of Oracle Corporation. Received on Mon Jun 10 1996 - 00:00:00 CEST

This message: [ Message body ]
Next message: Massimo Sgrelli: "TSN: packet write failure"
Previous message: Steve Long: "Re: Oracle Schema's"
In reply to: Kristiaan Boschman: "Oracle Schema's"
In reply to Kristiaan Boschman: "Oracle Schema's"
Next in thread: mtangaa_at_vip.cybercity.dk: "Re: Fragmented tablespaces?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message