Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Change Data Capture for ETL.

Re: Change Data Capture for ETL.

From: Bagavath <bagavath_at_gmail.com>
Date: Fri, 27 Apr 2007 23:46:10 -0400
Message-ID: <cc87d7290704272046t7f42087bj943176aec1f7c699@mail.gmail.com>


David,

Would you be willing to share some pain areas ? We have set up cdc ( async dist hot log ) for our warehouse but not into production yet. Except for a few glitches it seems to work so far, but we havent really put it to work with realtime data.

Thanks
Bagavath

On 4/27/07, David <thump_at_cosmiccooler.org> wrote:
>
> It's bleeding edge in 10202. We have it working, but it's been painful.
> As Tim mentioned, I wouldn't even attempt such under 9i.
> Tons of bugs and issues...
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Larry G. Elkins
> Sent: Friday, April 27, 2007 7:42 PM
> To: oracle-l_at_freelists.org
> Subject: RE: Change Data Capture for ETL.
>
> Do you care to clarify?
>
> Your comments about CDC prior to 10.2, is it mainly about performance, or
> is
> it about bugs, difficult to administer, or a combination of all?
>
> We've got some DW folks I work with a lot and they are wanting to use CDC,
> 9.2.0.7 for both source and target, which means it would still be using
> change tables somewhat similar to the MLOG$ tables along with triggers on
> the source table(s). They want this happening in "real time" against an
> already *very* active OLTP database.
>
> We have put them off (they are looking at sometime in the next six months
> to
> implement) until we can actually test the impact, and suggested testing
> streams also with the idea it would be lighter weight. Plus give us time
> to
> find out what business need they are really trying to solve with this
> "real
> time" requirement for data in the DW from the OLTP. In other words is this
> *really* needed to meet the business need they are trying to take care of.
> Or is there someway besides real time replication to meet the need? Don't
> know the answer.
>
> My understanding is that with CDC in 10g it is much lighter weight, using
> streams to hit the log files and AQ, and able to do asynchronously. It's
> been only the last few weeks that I've started to read up on CDC, able to
> spend an hour here or there trying to learn more about it. So any more
> information you have would be appreciated.
>
> Larry G. Elkins
> elkinsl_at_flash.net
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Tim Gorman
> Sent: Friday, April 27, 2007 5:34 PM
> To: Srini_Karla_at_harcourt.com
> Cc: oracle-l_at_freelists.org
> Subject: Re: Change Data Capture for ETL.
>
> Srini,
>
> I have, and I sincerely doubt that you'll have any fun with it below
> v10.2. But you can certainly have fun trying... ;-)
>
> Tim Gorman
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 27 2007 - 22:46:10 CDT

Original text of this message

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