Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Replication - What to use?
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