We are
working a SharePlex project from Quest. For our purposes (Financials) with
heavy adhoc (Cognos) we need to stay as close as possible to the production
instance. The advantage to SharePlex is that it is a log miner and hence
does not do a lot of sql against the source database. It is near real
time. Since this is not an Oracle product perhaps offline would be
a better place to discuss it. One disclaimer, we are still in
implementation and are not currently in production.
Allan
-----Original Message-----
From: Sai Selvaganesan [mailto:[EMAIL PROTECTED]
Sent: Monday, November 17, 2003 11:59 AM
To: Multiple recipients of list ORACLE-L
Subject: building a reporting databasehii am in the process of trying to firgure out the best way to model a reporting database . the source for the data in this database is a oltp system and i have figured out these three methods are good.- using aq and dq message processing- using snapshot replication- using ro standby databases.the last one will lag in data since standby database caanot have any archival log applied when opened in read only.is there any other good method to do this . my database is on 8.1.7.4thankssai
______________________________________________________________________________
This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216]
