I wrote the following trigger in Oracle:
create or replace trigger foreign_drop before ddl on database begin insert into ddl_log select ora_sysevent, ora_dict_obj_owner, ora_dict_obj_name, null, user, sysdate from dual; end foreign_drop;
It fires whenever a DDL event happens. But when I drop a foreign key constraint, nothing is recorded. Is dropping a foreign key constraints considered an event? How could I record the action of dropping a foreign key constraint?