ADD_CT_GROUPΒΆ

Add CT information to a CDC group.

Parameter Name

Required

DefaultValue

Description

p_ct_group

yes

ct group

p_description

yes

description

p_ct_status_sql

yes

ct status SQL

p_ct_db_status_sql

yes

ct database status SQL

p_ct_changes_sql

yes

ct changes SQL

Example

EXECUTE SCRIPT api_dbiadm.add_ct_group
           ( 'MYTEST_CT'
           , 'SQL Server Change Tracking1'
           , 'select 1 from dual'
           , 'select 1 from dual'
           , 'select 1 from dual'
           );