Select/find DDL Triggers
Hello,
as part of the Database Upgrade process (12.1->19.x) all DDL Triggers have to be disabled bevore.
But how to find if there are any?
Might be a statement like below but i am not able to find the where clause to catch all DDL cases
select owner as trigger_schema_name,
trigger_name,
trigger_type,
triggering_event,
table_owner as schema_name,
table_name as object_name,
base_object_type as object_type,
status,
trigger_body as script
from sys.dba_triggers
--restrict the result to trigger_type and/or event for DDL
order by trigger_name,
table_owner