Oracle-L: faster refreshes of Datamarts;Shareplex;ETL;Asynchronous Replication

From: Mandar A. Ghosalkar <mghosalk_at_byer.com>
Date: Thu, 11 Jul 2002 14:58:35 -0800
Message-ID: <F001.00495D5B.20020711145835@fatcity.com>

Hello guys,

i was wondering if any of ull use Quest Shareplex for Datawarehouse ETL and/or Reporting instance.

i am creating a data mart/reporting instance. The source database is a 7.3.4 on HP-ux 10.2

The destination(development) is 9i on Win2k. Still not figured out the platform for 9i (production).

has anyone used Shareplex to transfer logs from 7.3.4 to 9i on different platforms.
i havent worked with replication. are there sites which use readonly snapshots for creating reporting databases between different db versions. is it feasible and recommendable?
i am going to use direct path exp and also try to get exp compiled as single task. are there any success stories by making exp as single task.
The developers want to try out asynchronous replication on few of our large tables.

any tricks ull use to refresh reporting/datamarts having different versions. if the source had been 8/9 i would hv tried PEL or transportable tablespaces, but with 7.3.4 as sources i am short of ideas.

TIA
Mandar

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Mandar A. Ghosalkar
INET: mghosalk_at_byer.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

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 Jul 11 2002 - 17:58:35 CDT