REMOVE_CDC_GROUPΒΆ

Remove a CDC Group including dependent metadata.

Cleans out the following tables:

  • DBI_CDCG_CLEARANCE_LOG

  • DBI_CDCG_CLEARANCE_SETTINGS

  • DBI_CDCG_WATCH_LOG

  • DBI_CDCG_WATCH_BD

  • DBI_CDCG_WATCH

  • DBI_CDC_GROUPS

Does not delete DBI_LOADERS!

Parameter Name

Required

DefaultValue

Description

p_cdc_group

yes

CDC_GROUP

p_bdomain

no

BDOMAIN (empty=all)

Example: only one BDOMAIN

EXECUTE SCRIPT api_dbiadm.remove_cdc_group
           ( 'MYTEST'    -- p_cdc_group
           , 'R33'       -- p_bdomain
           );

Example: all BDOMAINS

EXECUTE SCRIPT api_dbiadm.remove_cdc_group
            ( 'MYTEST'   -- p_cdc_group
            , ''         -- p_bdomain
            );