BITimE // 咀嚼时光

今天给user重建（更新）trigge的时候遇到怪现象
下了create or replace trigger的SQL之后就得到ORA-03113的ErrorMessage,
我们的DB版本是9.0.1.4的
看了下面的Metalink上的资料后，
将用户的trigger的名称从原来的trigger_invoice换成了test_trigger_invoice之后，
就成功执行了
看来是Oracle 9.0.1.x的BUG

--comment:据说把现有的同名trigger先drop掉后在重建也能解决问题

================================================================

Oracle Server-Enterprise and Standard Edition/DBA Administration 技术论坛




以下显示的是所选线索的帖子。


线索 状态: 活动的

来自: M H 07-Jan-04 07:49
主题: 'ORA-03113: end-of-file on communication channel' -when compile trigger

RDBMS Version: 9.0.1.1
Operating System and Version: NT/2000
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.):
Product Version:

'ORA-03113: end-of-file on communication channel' -when compile trigger

Hello all,

I found some issue which is making me very curious.

If I create the trigger like below:

CREATE OR REPLACE TRIGGER EDIT_NOTIFICATION_U after update on NOTIFICATION for each row
begin
insert into NDS.XHIST_NOTIFICATION(
NOTIFICATION_ID,
DISEASE_NAME,
DISEASE_CODE
)
Values ( :OLD.NOTIFICATION_ID,
:OLD.DISEASE_NAME,
:OLD.DISEASE_CODE
);
end;
I get 'ORA-03113: end-of-file on communication channel' error and disconnect from Oracle.

And if i change the trigger name and replace the 'Edit_' and use other name it works fine. I mean:
CREATE OR REPLACE TRIGGER test_NOTIFICATION_U after update on NOTIFICATION for each row
begin
insert into NDS.XHIST_NOTIFICATION(
NOTIFICATION_ID,
DISEASE_NAME,
DISEASE_CODE
)
Values ( :OLD.NOTIFICATION_ID,
:OLD.DISEASE_NAME,
:OLD.DISEASE_CODE
);
end;

It doesnt like 'edit_' at the begining of the trigger name for update trigger. But if i use 'edit_' for the 'delete', it work fine.

Why it is happening? is it reserve word? any clue pls. Its just for my curisity. Thanks in advance.






--------------------------------------------------------------------------------


来自: Kadhirvelu@yahoo.com 07-Jan-04 08:48
主题: Re : 'ORA-03113: end-of-file on communication channel' -when compile trigger


Hi,
I tried a trigger with 'EDIT_NOTIFICATION_U' after update. It works fine. Try giving short name.



--------------------------------------------------------------------------------


来自: Oracle, Dean Riggio 07-Jan-04 16:50
主题: Re : 'ORA-03113: end-of-file on communication channel' -when compile trigger


I am not able to reproduce this behavior in 9.2. I was able to create a trigger using EDIT_ in the name with no problem. I don't have a 9.0 database to test on. It's possible that it's a bug in 9.0, but I can't verify. I would suggest opening a tar to oracle support if you want to pursue this futher.