日志里是看不到的。可以先建立一个my_log表,再定义一个系统触发器,
CREATE OR REPLACE TRIGGER SYS.drop_table
BEFORE DROP
ON DATABASE
DECLARE
BEGIN
insert into my_log(droptime,dropIP)values(sysdate,SYS_CONTEXT('USERENV','IP_ADDRESS')) EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END drop_table;/
CREATE OR REPLACE TRIGGER SYS.drop_table
BEFORE DROP
ON DATABASE
DECLARE
BEGIN
insert into my_log(droptime,dropIP)values(sysdate,SYS_CONTEXT('USERENV','IP_ADDRESS')) EXCEPTION
WHEN OTHERS THEN
-- Consider logging the error and then re-raise
RAISE;
END drop_table;/
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货