Oracle-L: RE: building a reporting database

From: C.S.Venkata Subramanian <csvenkata_at_lycos.com>
Date: Wed, 19 Nov 2003 22:59:58 -0800
Message-ID: <F001.005D7333.20031119225958@fatcity.com>

Hi All,
I have been working with client, where the refresh of the reporting instance is happening every 12 hrs due to business needs. This process is very well defined and the users are very happy. Even the concurrent requests are xfr to new reporting instance. I would take it offline and the process in fully driven by scripts and one good point is that we can continue from the point where it failed. --------- Original Message ---------
DATE: Tue, 18 Nov 2003 04:59:25
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Cc:

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-----
Sent: Monday, November 17, 2003 11:59 AM To: Multiple recipients of list ORACLE-L

i 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.4

thanks
sai

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]

Get advanced SPAM filtering on Webmail or POP Mail ... Get Lycos Mail! http://login.mail.lycos.com/r/referral?aid=27005

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: C.S.Venkata Subramanian
  INET: csvenkata_at_lycos.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Nov 20 2003 - 00:59:58 CST