ADD_CDCG_WATCHΒΆ
Add a watcher to a CDC group.
Parameter Name |
Required |
DefaultValue |
Description |
---|---|---|---|
p_cdc_group |
yes |
cdc group |
|
p_src_schema |
no |
source schema |
|
p_src_table |
no |
source table |
|
p_src_watch_id_expr |
yes |
source watch ID expression |
Example
EXECUTE SCRIPT api_dbiadm.add_cdcg_watch
( 'MYTEST' -- p_cdc_group
, 'apitest' -- p_src_schema
, 'apitestable' -- p_src_table
, 'to_date(add_hours(systimestamp, -21))' -- p_src_watch_id_expr
);