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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 07 Dec 2005 12:34:12 -0800
Message-ID: <1133987652.846322@jetspin.drizzle.com>


gbertele wrote:
> First of all, verson is 9.2.0.6 Enterprise Edition.
>
> Second, from the first reply above, I think maybe I was unclear about
> the requirements. 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? I was looking at it as a separate database, which would be that
> snapshot, and not have any effects from the continued data entry in the
> main DB.
>
> And, as mentioned, the tables that would be considered "shared" would
> be updated by both apps. The current reporting app points to our main
> DB, but this new "snapshot" requirement forces either a major change to
> app code, or a "snapshot" database, as I keep referring to it.
>
> All input is, as I said before, appreciated.
>
> Thanks!
>
> -George
>
>

>>>DA Morgan wrote:

>
>
>>>And the Oracle version and edition are?
>>>--
>>>Daniel A. Morgan
>>>http://www.psoug.org
>>>damorgan_at_x.washington.edu
>>>(replace x with u to respond)

Please do not top post.

Materialized View would be one solution.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Dec 07 2005 - 14:34:12 CST

Original text of this message

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