怎么看哪些TRIGGER是DISABLE的？

11 |

DBA把一些TRIGGER给DISABLE之后，发现没有地方看这些TRIGGER的具体状态是什么

千问 | 2010-10-8 09:31:21 | 显示全部楼层

本帖最后由 hwtong 于 2011-11-8 09:50 编辑
select owner,trigger_name,status from dba_triggers;

千问 | 2010-10-8 09:31:21 | 显示全部楼层

select owner,trigger_name,status from dba_triggers
where status='DISABLED';

千问 | 2010-10-8 09:31:21 | 显示全部楼层

SELECT object_name, status, owner, object_type FROM ALL_OBJECTSt WHERE object_type = 'TRIGGER';

千问 | 2010-10-8 09:31:21 | 显示全部楼层

SELECT object_name, status, owner, object_type FROM ALL_OBJECTSt WHERE object_type = 'TRIGGER' and status='INVALID'

千问 | 2010-10-8 09:31:21 | 显示全部楼层

SELECT object_name, status, owner, object_type FROM ALL_OBJECTSt WHERE object_type = 'TRIGGER' and status='INVALID'

主题	0 回帖	4882万积分

Rank: 8 Rank: 8

热门排行