Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 30506 invoked from network); 6 Jun 2006 19:08:56 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 6 Jun 2006 19:08:50 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0D4D734E01C;
 Tue,  6 Jun 2006 20:08:13 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 03704-02; Tue, 6 Jun 2006 20:08:12 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 686CC34E13F;
 Tue,  6 Jun 2006 20:08:12 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 06 Jun 2006 20:07:28 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D77BF34DD15
 for <oracle-l@freelists.org>; Tue,  6 Jun 2006 20:07:28 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 03575-09 for <oracle-l@freelists.org>;
 Tue, 6 Jun 2006 20:07:28 -0400 (EDT)
Received: from py-out-1112.google.com (py-out-1112.google.com [64.233.166.179])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2B65134E07C
 for <oracle-l@freelists.org>; Tue,  6 Jun 2006 20:07:26 -0400 (EDT)
Received: by py-out-1112.google.com with SMTP id i49so51077pyi
        for <oracle-l@freelists.org>; Tue, 06 Jun 2006 17:07:23 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:mime-version:content-type;
        b=Us4UNTYULGcti38N5ZaQk5g1IZ9rHZsRZYBOry9Ym9XYwWcyHPE8zQp1cprl+HCl45Z5nKAb/O8riVnGkgBsYCWvYVx8ROjpGESJgLDH47pfdsvNGZFedsuvW9IINioGc3YF+dD7GvMxnwogBpyDqK2tX8Ws8TVLUyIj0viK8yQ=
Received: by 10.35.91.15 with SMTP id t15mr150904pyl;
        Tue, 06 Jun 2006 17:07:23 -0700 (PDT)
Received: by 10.35.57.7 with HTTP; Tue, 6 Jun 2006 17:07:23 -0700 (PDT)
Message-ID: <1c1a62990606061707l60fdd4d4xfcb8312c82c88ff@mail.gmail.com>
Date: Tue, 6 Jun 2006 17:07:23 -0700
From: "Arul Ramachandran" <contactarul@gmail.com>
To: oracle-l@freelists.org
Subject: Asynchonous CDC in 10GR2
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="----=_Part_32139_13301593.1149638843736"
X-archive-position: 35683
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: contactarul@gmail.com
Precedence: normal
Reply-to: contactarul@gmail.com
X-list: oracle-l
X-Virus-Scanned: by amavisd-new-20030616-p10 (Debian) at avenirtech.net
------=_Part_32139_13301593.1149638843736
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

 I checked out Async CDC a couple of months ago, but currently I do not have
a 10GR2 environment.

I have a few questions on Asynch CDC, in regards to setting up the change
table.

1. After letting dbms_cdc_publish.create_change_table create the change
table, is it ok to (manually) add columns to it? I need to add a couple of
snapshot columns that are not present in the base table.

2. Would it be possible to implement a database insert trigger on the change
table to populate the snapshot columns of the change table?

3. Does Async CDC partition the change table automatically? If so, what is
the partitioning scheme? (The manual simply tells "Change Data Capture
automatically manages the change table partitioning as part of its change
table management")
Thanks in advance,
-- 
Arul

------=_Part_32139_13301593.1149638843736
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>Hi,</div>
<div>&nbsp;</div>
<div>
<div>I checked out Async CDC a couple of months ago, but currently I do not have a 10GR2 environment.</div>
<div>&nbsp;</div></div>
<div>I have a few questions on Asynch CDC, in regards to setting up the change table.</div>
<div>&nbsp;</div>
<div>1. After letting dbms_cdc_publish.create_change_table create the change table, is it ok to (manually) add columns to it? I need to add a couple of snapshot columns that are not present in the base table.</div>
<div>
<p>2. Would it be possible to implement a database insert trigger on the change table to populate the snapshot columns of the change table?</p>
<p>3. Does Async CDC partition the change table automatically? If so, what is the partitioning scheme? (The manual simply&nbsp;tells &quot;Change Data Capture automatically manages the change table partitioning as part of its change table management&quot;)
</p>Thanks in advance,<br>-- <br>Arul </div>

------=_Part_32139_13301593.1149638843736--
--
http://www.freelists.org/webpage/oracle-l