How to drop all triggers within given DB in Oracle at once?

Question

How to drop (remove, delete) all triggers within given DB.

Problem is that application requires DB upgrade and does not proceed triggers (suport, drop, create) after upgrade, application upgrade fails.

Answer 1

This will generate the command how to drop all triggers in current schema:

select 'drop trigger ' || trigger_name || ';' stmt from user_triggers;

Answer 2

You can create a script for dropping triggers by using the Oracle system tables, like this:

select 'drop trigger ' || owner || '.' || trigger_name || ';' from all_triggers

Note that there are 3 views containing triggers:

• all_triggers = all the triggers you have permission to know about (regardless of which schema they belong to)
• user_triggers = the triggers that belong to your own schema
• dba_triggers = for DBA's