Re: Multi Instances vs Multi Schemas

Parm wrote:
>
> 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..

I prefer multi schemas..

-- 
******************************************************************************
AMARENDRA B NETTEM			5039 N E River Road, Apt. 1A
Certified Oracle DBA			NORRIDGE, IL 60656
Whittman-Hart Inc., 
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.  

Ph.No. (708) 583 9870 (H)  
       (312) 913 6758 (W)  

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************************
Opinions are mine and do not necessarily reflect those of Whittman-hart
Inc.