Re: streams insert - update - commit error handler
- From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
- To: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- Date: Tue, 16 Sep 2008 10:40:01 +0700
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@xxxxxxxxx> 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@xxxxxxxxx>
> 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 :)
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
