Re: Exporting Triggers

A couple of self-checking scripts you can run to see what might be happening:

select owner, object_name, object_type

	from dba_objects
	where object_name like '%DISTINCT_RUNS%'
	   or object_name like '%DISTINCT_BLOCKS%';

select * from dba_triggers
	where trigger_name in ('TR_DISTINCT_BLOCKS','TR_DISTINCT_RUNS');