Asynchronous Hotlog CDC - Change Table not Capture the Change Data
edited Feb 25, 2010 2:51AM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
i'm using Asynchronous Hotlog CDC to capture change data from a table. I configure my Oracle db 10.2.0.1. following Performing Asynchronous HotLog Publishing & Subscribing to Change Data in B14223-02 documentation. There is no error message but the change table not capture the change data in source table.
i'm using predefined change source, HOTLOG_SOURCE when create change set:
BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
change_set_name => 'CSET_BARANG',
description => 'Change set for product',
change_source_name => 'HOTLOG_SOURCE',
stop_on_ddl => 'y',
begin_date => sysdate,
end_date => sysdate + 30);
END;
but when i query select * from sys.CDC_CHANGE_SOURCES$ ; the result is
i'm using predefined change source, HOTLOG_SOURCE when create change set:
BEGIN
DBMS_CDC_PUBLISH.CREATE_CHANGE_SET(
change_set_name => 'CSET_BARANG',
description => 'Change set for product',
change_source_name => 'HOTLOG_SOURCE',
stop_on_ddl => 'y',
begin_date => sysdate,
end_date => sysdate + 30);
END;
but when i query select * from sys.CDC_CHANGE_SOURCES$ ; the result is
0