Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: One vs many databases

Re: One vs many databases

From: J Alex <jalexanderssd_at_yahoo.com>
Date: Fri, 03 Jan 2003 22:07:57 GMT
Message-ID: <1RnR9.62371$j8.1706544@twister.tampabay.rr.com>

"Anton Buijs" <aammbuijs_at_xs4all.nl> wrote
> These are a few of my considerations
>
> Don't store applications in one database that don't have anything in
common:
> a. when upgrading both applications must upgrade at the same time
> b. maintenance for one application (where you really want to close access
to
> the db completely) could imply unnecessary downtime for the other
> application
> c. when the database needs to be restored completely (because one
> application screwed up the data in a yearly batch or so or block
corruptions
> occur and the db runs in noarchivelog mode) the other applications loose
> data too.

I'd add one more - if the application has more than one occurrence, each one should have a separate database (e.g. if both a division and corporate headquarters run independent copies of Oracle Financials). Received on Fri Jan 03 2003 - 16:07:57 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US