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
           );