CREATE TABLE event_ddl(
event VARCHAR2(40),
username VARCHAR2(40),
owner VARCHAR2(30),
obbjname VARCHAR2(40),
objtype VARCHAR2(100),
time DATE
);
CREATE OR REPLACE TRIGGER tr_ddl
AFTER DDL ON database
BEGIN
Declare
Cursor C1 is
select
ora_sysevent,
ora_login_user,
ora_dict_obj_owner,
ora_dict_obj_name,
ora_dict_obj_type,
SYSDATE
from dual;
BEGIN
FOR C2 IN C1 LOOP
null;
INSERT INTO event_ddl VALUES(
C2.ora_sysevent,
C2.ora_login_user,
C2.ora_dict_obj_owner,
C2.ora_dict_obj_name,
C2.ora_obj_type,
C2.SYSDATE
);
END LOOP;
END;
END;
/