CREATE OR REPLACE TRIGGER save_our_db
BEFORE TRUNCATE
ON database
BEGIN
IF ora_dict_obj_type IN ('TABLE') AND (sys_context('USERENV', 'HOST') not IN ('paynode1','paynode1')) THEN
raise_application_error(num => -20001, msg => 'you can not allow to truncate ' || ora_dict_obj_name || '!');
END IF;
END save_our_db;
/
BEFORE TRUNCATE
ON database
BEGIN
IF ora_dict_obj_type IN ('TABLE') AND (sys_context('USERENV', 'HOST') not IN ('paynode1','paynode1')) THEN
raise_application_error(num => -20001, msg => 'you can not allow to truncate ' || ora_dict_obj_name || '!');
END IF;
END save_our_db;
/
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/22392018/viewspace-709959/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/22392018/viewspace-709959/