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: Replication - What to use?

Re: Replication - What to use?

From: Walt <walt_askier_at_SHOESyahoo.com>
Date: Thu, 08 Dec 2005 14:56:59 -0500
Message-ID: <fe0mf.2086$yb2.361@news.itd.umich.edu>


gbertele wrote:

> First of all, verson is 9.2.0.6 Enterprise Edition.
>
> Without some soft of replication, how can the
> reporting app report on a "snapshot in time" while the main app
> continues to update the DB with all sorts of data entry continuing to
> occur?

The ability to do this (wihthout impacting performance) is exactly what distinguishes Oracle from some other RDMS. Yes, Oracle can give you a "snapshot in time" while your app continues to update the data. You don't need replication to do this.

Google "Oracle multiversion read consistency"

//Walt Received on Thu Dec 08 2005 - 13:56:59 CST

Original text of this message

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