1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
| CREATE TABLE WMCDDL (username varchar2(30),
datetrig DATE,
ddl_type VARCHAR2(30),
obj_owner VARCHAR2(30),
obj_type VARCHAR2(12),
obj_name VARCHAR2(30),
src VARCHAR2(4000));
CREATE TRIGGER DDLTrigger
AFTER DDL ON DATABASE
BEGIN
INSERT INTO WMCDDL(USERNAME, DATETRIG, DDL_TYPE, OBJ_OWNER, OBJ_TYPE, OBJ_NAME, SRC)
SELECT ora_login_user, SYSDATE, ora_sysevent, ora_dict_obj_owner, ora_dict_obj_type, ora_dict_obj_name, text
FROM all_source
WHERE NAME=ora_dict_obj_name
AND owner=ora_dict_obj_owner
AND TYPE = ora_dict_obj_type;
END; |
Partager