Re: Change Data Capture for ETL.

  • From: "David Lord" <dlordster@xxxxxxxxx>
  • To: Srini_Karla@xxxxxxxxxxxx
  • Date: Sat, 28 Apr 2007 07:10:49 +0100

Srini,

We've been using it in production on 9.2.0.6 since the middle of last
year with very few problems.  Its a bit limited, but it works.  Its
only a log table and an internal DML trigger in the end, so there's
not really a great deal to go wrong.

Incidently, we tried streams in 9.2 but it fell over immediately
because the source tables had function-based indexes on them.

David Lord

On 27/04/07, Karla, Srini (HAS-SAT) <Srini_Karla@xxxxxxxxxxxx> wrote:
Any one implemented Change data capturing method to load into Data
warehousing. Is it work ok in Oracle 9.0.1.4


Thanks,
Srini Karla
Sr. Database Administrator,
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l


Other related posts: