Database Administration (MOSC)

MOSC Banner

Select/find DDL Triggers

edited Sep 21, 2020 5:31AM in Database Administration (MOSC) 9 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center