TRIGGER: SYS.CDC_CREATE_CTABLE_BEFORE

Source

Description

sys.cdc_create_ctable_before
  BEFORE
    CREATE ON DATABASE
    

Type

BEFORE 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,'LOCK');
      END IF;
      END;