这样试试:
CREATE OR REPLACE TRIGGER tr_ddl
before ALTER DDL -- 此处可能不需要ddl
ON yqj.schema--其中yqj为我的表空间和登陆账号密码
BEGIN
INSERT INTO event_ddl VALUES(
ora_sysevent,
ora_login_user,
ora_dict_obj_owner,
ora_dict_obj_name,
ora_dict_obj_type,
SYSDATE
);
END;