给你个修改表的触发器吧
CREATE TABLE alter_audit_trail(
object_owner VARCHAR2(30),
object_name VARCHAR2(30),
object_type VARCHAR2(30),
alter_by_user VARCHAR2(30),
sys_event VARCHAR2(30),
alteration_time DATE);
-- 当用户创建、修改或删除时的模式触发器。
CREATE OR REPLACE TRIGGER tri_alter_audit_trail
AFTER ALTER OR CREATE OR DROP ON scott.SCHEMA
BEGIN
IF sys.sysevent = 'ALTER' THEN
INSERT INTO alter_audit_trail VALUES
(sys.dictionary_obj_owner, sys.dictionary_obj_name,
sys.dictionary_obj_type, sys.login_user, 'my_alter', sysdate);
ELSIF sys.sysevent = 'CREATE' THEN
NULL;
ELSIF sys.sysevent = 'DROP' THEN
NULL;
END IF;
END; 


转自网络
ITPub博客

oracle ddl 触发器

最新文章
