OraFAQ Forum: Streams & AQ » How to capture previous data in CDC

Blog
Search
Help
Members
Register
Login
Home

Home » Server Options » Streams & AQ » How to capture previous data in CDC

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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.

Report message to a moderator

Previous Topic:	AQ Error AIP-13122
Next Topic:	Purging a queue takes longer then expected

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 14 02:08:58 CST 2026