||Oracle Tips by Burleson
Sometimes triggers cause problems and you need to
turn them off temporarily. This is an easy procedure as shown in the
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.
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
Download your Oracle scripts now:
definitive Oracle Script collection for every Oracle professional DBA