Re: Use One or Two Databases?

In article <3gta6d$r7s_at_aplcomm.jhuapl.edu>, Stan Novinsky <stan_novinsky_at_jhuapl.edu> writes:
> Hopefully someone out in ORACLE land can comment and
> advise on this. I have received a lot of valuable
> information from this working group. Thanks for all of
> your comments and help (Lisa, Tony, Lucie...). On to the
> important issues.
>
> We want to set up a DB system (ORACLE) that may have to be
> used by two projects each with different needs. The
> computer configuration at this time is:
>
> - VAX 4000/90 running OpenVMS 6.1.
> - 3 RZ28's (2 GB each)
> - 128 Meg Memory
> - Ada, C, Motif, DECmessageQ
>
> a. Is it best to have one DB and separate the projects by
> tablespaces.
>
> b. Have two separate DB's one for each project. If so,
> how are the tablespace/datafiles placed on the drives.
>
> An issue that we must consider is the one project will be
> transferred to a target system at a later time.
>
> Thanks
>
> stan_novinsk_at_jhuapl.edu
>
>

A rule of thumb in these cases is that if you anticipate differences in the project requirements to result into having to change init.ora parameters, use two databases. If the requirements are mostly space/quota related, you can use two tablespaces.

Sorry, it's hard to be more specific than that.

-- 
========================================================================
Vipin Gokhale
DEC SBU
Oracle Corporation
Disclaimer:         Any opinions expressed here are mine and not that of
                    my employer.
========================================================================