除了删除该触发器,编译,重写都会报锁超时,但我查死锁没查出什么东东。SQL> drop trigger JX_TR_USER_UPDATE;
drop trigger JX_TR_USER_UPDATE
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object D7IP.JX_TR_USER_UPDATE
drop trigger JX_TR_USER_UPDATE
*
ERROR at line 1:
ORA-04021: timeout occurred while waiting to lock object D7IP.JX_TR_USER_UPDATE
连接到:
Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production
With the Partitioning option
JServer Release 9.0.1.1.1 - ProductionSQL> create table t1(cid int);表已创建。SQL> create table t2 as select * from t1;表已创建。SQL> create or replace trigger trg_test after update on t1
2 for each row begin
3 insert into t2 values(:new.cid);
4 end;
5 /触发器已创建SQL> insert into t1 values(1);已创建 1 行。SQL> commit;提交完成。SQL> update t1 set cid=2 where cid=1;已更新 1 行。SQL> commit;提交完成。SQL> select * from t2; CID
----------
2SQL> drop trigger trg_test;触发器已丢弃