--禁用alter table t disable all tirggers;--启用alter table t enable all triggers;
SQL code --禁用 alter table t disable all tirggers; --启用 alter table t enable all triggers; 报错:ORA_00054:resource busy and acquire with NOWAIT specified. 是因为 disable all triggers 时,all triggers中含有自身的缘故吗?
alter trigger <triggername> disable/enablealter table <tablename> disable all trigger|enable all trigger
alter table <tablename> disable all trigger ¦enable all trigger 这个能具体解释下是什么意思吗?
允许或者禁止所有在这个表上面的触发器。 alter table <tablename> disable all trigger alter table <tablename> enable all trigger
declare
v_name varchar2(50);
begin
select trigger_name into v_name from dba_triggers
where table_name='XXX';
execute immediate 'alter trigger '||v_name||' disable';
end;
/
根据返回的数据值判断:如果返回值为1 就disable 触发器A还可以啊?
--禁用alter table t
disable all tirggers;--启用alter table t
enable all triggers;
--禁用 alter table t disable all tirggers; --启用 alter table t enable all triggers; 报错:ORA_00054:resource busy and acquire with NOWAIT specified.
是因为 disable all triggers 时,all triggers中含有自身的缘故吗?
alter table <tablename> disable all trigger ¦enable all trigger
这个能具体解释下是什么意思吗?
alter table <tablename> disable all trigger
alter table <tablename> enable all trigger