How To Disable System Triggers in Oracle

In the database, it may sometimes be necessary to disable system triggers during operations such as java installation, downgrade, or upgrade. An error in a system trigger that we create can cause serious problems in the database. In these cases, system triggers may need to be disabled.

To disable system triggers, the value of parameter _system_trig_enabled must be set to false. We can learn the current value of this parameter with the following query.

We can change the parameter as follows.

You can use the following query to find out which triggers will be disabled.

The events that the parameter will affect are as follows:

Resource Manager Events

  • STARTUP
  • SHUTDOWN
  • SERVERERROR

Client Events

  • AFTER LOGON
  • BEFORE LOGOFF
  • BEFORE CREATE
  • AFTER CREATE
  • BEFORE ALTER
  • AFTER ALTER
  • BEFORE DROP
  • AFTER DROP
  • BEFORE ANALYZE
  • AFTER ANALYZE
  • BEFORE ASSOCIATE STATISTICS
  • AFTER ASSOCIATE STATISTICS
  • BEFORE AUDIT
  • AFTER AUDIT
  • BEFORE NOAUDIT
  • AFTER NOAUDIT
  • BEFORE COMMENT
  • AFTER COMMENT
  • BEFORE CREATE
  • AFTER CREATE
  • BEFORE DDL
  • AFTER DDL
  • BEFORE DISASSOCIATE STATISTICS
  • AFTER DISASSOCIATE STATISTICS
  • BEFORE GRANT
  • AFTER GRANT
  • BEFORE RENAME
  • AFTER RENAME
  • BEFORE REVOKE
  • AFTER REVOKE
  • BEFORE TRUNCATE
  • AFTER TRUNCATE

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *