DBA Data[Home] [Help]

TRIGGER: SYS.CDC_CREATE_CTABLE_AFTER

Source

Description
sys.cdc_create_ctable_after
  AFTER
    CREATE ON DATABASE
    
Type
AFTER EVENT
Event
CREATE 
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;