如何更改trigger 的debuginfo今天在数据库里查到有些trigger的debuginfo是true
请问,如何把这些trigger的debug改为false?
请问,如何把这些trigger的debug改为false?
解决方案 »
- dba_tab_partitions查询
- 三个想通过oracle(plsql)实现的查询
- 数据库备份
- java程序中如何用RunTime执行sql plus命令
- 超级菜鸟提问:需要那些软件呢?
- 请问有谁知道google的后台数据库是用什么数据库?
- SQL PLUS 与sql plus worksheet 的区别
- 在oracle中怎么查看刚执行的语句???
- 求教一个sql语句
- C#插入oracle10g个别表很慢
- 我想关闭10g的sga内存自动管理,但是不知道如何调整内存参数,请教
- [求助]Warning: Procedure created with compilation errors的问题.
就可以看到debuginfo
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.1describes 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.
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 Fsys@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
http://space.itpub.net/13129975/viewspace-626245