Re: More than one database on a system? Was: need advice on filesystem layout

In article <Pine.SUN.3.91.951107094836.2000A-100000_at_seatimes>, Steve Butler <sbut-is_at_seatimes.com> wrote:

> > This brings to mind a question that I have regarding several database
> > systems that I will be consolidating to one AIX box. Our plan is to create
> > one database and segregate the various applications by tablespace. Is
> > there any reason to use multiple databases instead of one?
>
> Different backup frequencies. Ability to restore and recover one
> application seperate and distinct from the others. Ability to move one
> application to another box when the sum becomes to big for a single box.
>
> Flexibility -- the art of being flexible.

Aren't all of these capabilities possible with running one database but segregating applications to their own tablespaces? Maybe not with cold backups but the other capabilities - restore and recover, move to another box, should all be possible/not too complex with the one database scheme, or no?

-- 
Mike McCurdy    mccurdy_at_ucsvax.sdsu.edu
AIX/VMS System Management
Oracle Database Administration
University Computer Operations
San Diego State University