提供一个关于统计某用户模式下曾经被删对象的触发器代码

首先是创建一张表：
        zwm_scott_droped_objects
          object_name varchar2(30)
          object_type varchar2(20)
          droped_time date
然后编写触发器代码
create or replace trigger zwm_log_droped_trigger
before drop on scott.schema
begin
  insert into zwm_scott_droped_objects values(
              ora_dict_obj_name,
              ora_dict_obj_type,
              sysdate);
end;