 |
|
Oracle Tips by Burleson |
Disabling/Enabling Triggers
Sometimes triggers cause problems and you need to
turn them off temporarily. This is an easy procedure as shown in the
example below.
alter trigger
sales_history_tr disable;
alter trigger sales_history_tr enable;
A disabled trigger remains in
the database but will not execute. To remove a trigger from the
database, simply drop it.
drop trigger
sales_history_tr;
Triggers are a powerful tool when used correctly.
Triggers are the basis for many of the advanced capabilities built
into the Oracle database such as multi-master replication and
materialized views.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
