Re: streams insert - update - commit error handler

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Tue, 16 Sep 2008 10:40:01 +0700
Message-ID: <3edcb66e0809152040p24d3cdd2j84b5e733c937cc0a@mail.gmail.com>


hi roman,

I have enabled PK and UI supplement log for this replication.

-- 
thanks and regards
ujang | oracle dba
jakarta | http://ora62.wordpress.com

On Mon, Sep 15, 2008 at 9:12 PM, Roman Podshivalov
<roman.podshivalov_at_gmail.com> wrote:

> Hi,
>
> What kind of supplemental logging you have turned on for DIALCODES table ?
> As you can see in the trace some values are reported as "no available value"
> for where clause of your update:
>
> knipdmpargs: dump new argument list:
> column: "DCID"
> no available value
> column: "DCIDPARENT"
> no available value
> column: "DCTEXT"
> no available value
> column: "DCTYPE"
> (dty, kncdty, acl, csf, csi, ind)=(1,0,3,1,31,0)
> value = XXX
> column: "DCVALIDFROM"
> no available value
> column: "DCVALIDTO"
> no available value
> column: "DCVALUE"
> no available value
>
> As of creating the band aid solution with an error handler - I personally
> think you gotta just configure streams correctly and do not reinvent the
> bicycle 8-)
>
> --romas
>
> On Mon, Sep 15, 2008 at 9:18 AM, Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
> wrote:
>>
>> lists,
>>
>> I have tested streams on very simple configuration, which consist of
>> source and destination database.
>> for all simple transactions there are no serious conflict/error, but
>> with this kind of transaction, the apply process become stuck :)
>
-- http://www.freelists.org/webpage/oracle-l
Received on Mon Sep 15 2008 - 22:40:01 CDT

Original text of this message