??????????:
?????????μ?????????????drop?????????:

/**
* drop????????????
*/
create table drop_log
(
session_id int not null?? -- sessionid
drop_time date?? -- drop?????
ip_address varchar2(20)?? -- ip???
object_owner varchar2(30)?? -- ???????????
object_name varchar2(30)?? -- ????????
object_type varchar2(20)?? -- ????????
drop_by_user varchar2(30) -- ???drop???????
);
create or replace trigger drop_info
after drop on mfg0513user.schema -- ??mfg0513user???????????DROP???????
begin
insert into drop_log
(session_id??
drop_time??
ip_address??
object_owner??
object_name??
object_type??
drop_by_user)
values(USERENV('SESSIONID')??
sysdate??
SYS_CONTEXT('USERENV'??'IP_ADDRESS')??
sys.dictionary_obj_owner??
sys.dictionary_obj_name??
sys.dictionary_obj_type??
sys.login_user);
end;