当前位置：首页 → 问答吧 → 如何更改trigger 的debuginfo

如何更改trigger 的debuginfo

时间：2011-09-15

来源：互联网

如何更改trigger 的debuginfo

今天在数据库里查到有些trigger的debuginfo是true
请问，如何把这些trigger的debug改为false？

作者: xkx2003 发布时间: 2011-09-15

你是怎么查到滴？能把语句贴出来不？

作者: luoyoumou 发布时间: 2011-09-15

dba登陆

select * from all_probe_objects
就可以看到debuginfo

作者: xkx2003 发布时间: 2011-09-15

引用 2 楼 xkx2003 的回复:

dba登陆

select * from all_probe_objects
就可以看到debuginfo

-- 这是数据字典表，是不能(也不应该)直接更新的!

作者: luoyoumou 发布时间: 2011-09-15

SQL code

-- 看 Tom 回答人家的：
You Asked
Hi,

What is this view - all_probe_objects and its significance ?

thanks
Apraim
and we said...
it is used internally as part of PLSQL debugging.

Metalink note Article-ID:      Note 231349.1

describes this more fully, it is basically useful to see if a procedure was compiled debug or not.

beyond that, it does not do anything. It is not installed by default, the dba would need to install it.

作者: luoyoumou 发布时间: 2011-09-15

SQL code

-- 只能这样修改：
sys@TBWORA> select OWNER, OBJECT_NAME, debuginfo from  all_probe_objects where object_type='TRIGGER' and OWNER='SCOTT';

OWNER                          OBJECT_NAME                    DE
------------------------------ ------------------------------ --
SCOTT                          T_TRIG_AUTOINC                 F

sys@TBWORA> ALTER TRIGGER SCOTT.t_trig_autoinc COMPILE DEBUG;

触发器已更改

sys@TBWORA> select OWNER, OBJECT_NAME, debuginfo from  all_probe_objects where object_type='TRIGGER' and OWNER='SCOTT';

OWNER                          OBJECT_NAME                    DE
------------------------------ ------------------------------ --
SCOTT                          T_TRIG_AUTOINC                 T