TRIGGER: SYS.CDC_ALTER_CTABLE_BEFORE

Source

Description

sys.cdc_alter_ctable_before
  BEFORE
    ALTER ON DATABASE
    

Type

BEFORE EVENT

Event

ALTER 

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN
      /* NOP UNLESS A TABLE OBJECT */
      IF dictionary_obj_type = 'TABLE'
      THEN
        sys.dbms_cdc_ipublish.change_table_trigger(dictionary_obj_owner,dictionary_obj_name,sysevent);
      END IF;
      END;