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