Multi Instances vs Multi Schemas

From: Parm <miths_at_netcom.ca>
Date: 1997/09/16
Message-ID: <01bcc29c$f5058e40$6848b5cf@capppmiths>#1/1

Hi Everybody,

My question is: Suppose one company has more than one branches and every branch wants to be independent but on times they need to share the information, in this situation what will be the right way ... multi schemas or
multi instances..? and every company wants to share the customer table and other rules and validation tables..

All suggestions will be welcomed. Also what will the backup and recovery cycles
and if one company wants to backup the other should be running.

Ofcourse i m talking this for oracle 7.3 on unix platform.

Parm

e-mail: miths_at_netcom.ca

PS: Please dont email me any commercials... But all technical suggestions, discussions, questions will be highly appreciated.. Received on Tue Sep 16 1997 - 00:00:00 CDT