sys.cdc_drop_ctable_before
BEFORE
DROP ON DATABASE
Type
BEFORE EVENT
Event
DROP
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;