Home » Server Options » Streams & AQ » How to capture previous data in CDC
icon12.gif  How to capture previous data in CDC [message #178982] Fri, 23 June 2006 13:47
eddula
Messages: 1
Registered: June 2006
Location: New York
Junior Member

Hi,

Can anyone know how to capture previous data in CDC. I am using below script to create change set with previous ten days. but it is not capturing data.

begin
  dbms_cdc_publish.create_change_set(
  change_set_name =>'test_tab1',
  description =>'change set for test_tab1',
  change_source_name=>'HOTLOG_SOURCE',
  stop_on_ddl=>'y',
   begin_date=> (sysdate-10),
   end_date=>null);
   end;
/


Thanks in advance.
Previous Topic: AQ Error AIP-13122
Next Topic: Purging a queue takes longer then expected
Goto Forum:
  


Current Time: Thu Mar 28 08:04:28 CDT 2024