--

create or replace trigger mdsys.sdo_drop_user
after drop on database
declare 
   stmt varchar2(200);
begin
     if dictionary_obj_type = 'user' then
       stmt := 'delete from sdo_geom_metadata_table ' ||
               ' where sdo_owner = ''' || dictionary_obj_name || ''' ';
       execute immediate stmt;
    end if;
end;


---

create or replace trigger sys.aurora$server$startup after startup on database 
call dbms_java.server_startup

 

-- 

create or replace trigger sys.jis$role_trigger$ after drop on database 
when (ora_dict_obj_type='role')
begin
    sns_context.role_dropped(ora_dict_obj_name);
    http_security_cascade.principal_dropped(ora_dict_obj_name);
  end;

--删除前备份数据的器

create or replace trigger yspj.t_bill_remain_del
before delete on bill_remain

for each row

begin
insert into bill_remain_tiger
values(:old.bill_remainid,:old.bill_typeid,:old.remain_num,:old.add_time,:old.org_id,
:old.state,:old.bill_id,'删除记录',sysdate,user);

end;