use db link between the 2 DB and snapshots in the reporting DB with the refresh rate you want

----- Original Message -----
From: genegurevich <oracledba-ezmlmshield-x82911943.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Subject: real-time data wareohusing.
Date: Mon, 27 Dec 2004 16:53:46 -0600

>
>
>
>
>
> Hi all:
>
> Does anyone has any experience with real-time data warehousing? At my work
> the business wants to create a
> real-time reporting environment for some transactions and we are looking at
> how to get the data from the operational
> environment into the reporting one in the "real" time (may be once every
> hour). One option that we touched upon
> was using a logminer to get all the inserts made into a specific table and
> use the output to copy the data into
> the reporting DB. Has someone tried using the logminer in such mode? Any
> other options (besides dumping
> operational data into a flat file every hour) to accomplish the "real" time
> reporting?
>
>
> thank you
>
> Gene Gurevich
>
>
>
> --------
> website: http://www.LazyDBA.com
> Please don't reply to RTFM questions
> Oracle documentation is here: http://tahiti.oracle.com
> To unsubscribe: see http://www.lazydba.com/unsubscribe.html
> To subscribe: see http://www.lazydba.com
> By using this list you agree to these terms:http://www.lazydba.com/legal.html



DEGAND XAVIER

DX SPRL

BRUSSELS, BELGIUM


Oracle LazyDBA home page