Enabling and Disabling Triggers

A trigger can be in one of two distinct modes:

Enabled. An enabled trigger executes its trigger body if a triggering statement is entering and the trigger constraint (if any) evaluates to TRUE.

Disabled. A disabled trigger does not execute its trigger body, even if a triggering statement is entered and the trigger restriction (if any) evaluates to TRUE.

Enabling Triggers

By default, a trigger is automatically enabled when it is created; however, it can later be disabled. After you have completed the task that required the trigger to be disabled, re-enable the trigger, so that it fires when appropriate.

Enable a disabled trigger using the ALTER TRIGGER statement with the ENABLE option. To enable the disabled trigger named REORDER of the INVENTORY table, enter the following statement:

ALTER TRIGGER Reorder ENABLE;

All triggers defined for a specific table can be enabled with one statement using the ALTER TABLE statement with the ENABLE clause with the ALL TRIGGERS option. For example, to enable all triggers defined for the INVENTORY table, enter the following statement:

ALTER TABLE Inventory

ENABLE ALL TRIGGERS;

Disabling Triggers

You might provisionally immobilize a trigger if:

An object it references is not nearby.
You need to execute a large data load, and you want it to carry on quickly without firing triggers.
You are reloading data.
By default, triggers are enabling when first created. Bring to a halt a trigger using the ALTER TRIGGER statement with the DISABLE option.

For example, to disable the trigger named REORDER of the INVENTORY table, enter the following statement:

ALTER TRIGGER Reorder DISABLE;

All triggers associated with a table can be disabling with one statement using the ALTER TABLE statement with the DISABLE section and the ALL TRIGGERS option. For example, to immobilize all triggers distinct for the INVENTORY table, enter the following statement:

ALTER TABLE Inventory

DISABLE ALL TRIGGERS;

Viewing Information about Triggers

The following data dictionary views make known information about triggers:

USER_TRIGGERS
ALL_TRIGGERS
DBA_TRIGGERS

The new column, BASE_OBJECT_TYPE, specifies whether the trigger is based on DATABASE, SCHEMA, table, or view. The old column, TABLE_NAME, is unacceptable if the base object is not table or view.

The column ACTION_TYPE specifies whether the trigger is a call type activate or a PL/SQL trigger.

The column TRIGGER_TYPE includes two additional values: BEFORE EVENT and AFTER EVENT, appropriate only to system events.

The column TRIGGERING_EVENT includes all system and DML events.

Enabling and Disabling Triggers
Champaign Urbana Limousine Service Ecommerce Software Services & Packages PPC Campaign Pay Per Click Management Overview of Events and Behavior Tracking Custom Performance Tracking Reports Limousine Rentals Weddings and Ceremonies Content Management Systems MVI Internet Marketing Strategy The Importance of Event Tracking in Web Analytics Limousines in Idaho Web Hosting MVI Reporting & Analytics SEO Investments On The Rise Wedding Limousine Rental Tips Limopros in Phoenix Reporting & Analytics Adding Event Triggers for Interactivity Custom Web Application Development Web Application Development Outsourcing Company LIMOPROS USA Limousine Party Bus Limo Bus Charter Bus Services Web Site Content Writers ECommerce Development Company Real-Time Web Site Tracking Getting Started Tracking Prom Limo Service in San Francisco Limoprose For All Events and Occasions Quality Ecommerce Website Design Service Web Site Visitor Tracking Las Vegas Car Service and Limo Service Corporate Events Limo Toronto The Hunt for Stats Tracking Email and Clear Pixels San Francisco Limo Service Why Are Our Tanning Beds Different Customer Relationship Management (CRM) What Is It MVI Internet Marketing Trigger Events and Selective Perception Triggered Campaigns 3 Things to Keep In Mind The Safety Of Indoor Tanning E-Commerce Solutions MVI Web Design Solution Enabling and Disabling Triggers Trigger Event Strategist Glaucoma Internet Marketing Services Customer Relationship Management Application Airport Services Indoor Tanning Accessories For Men and Women Event Triggers (Methods) Windows7 Trigger Start Services Guaifenesin Wedding Limo Georgia Style Home Tanning Bed Strategic Planning & Marketing Strategies Enable Growth Pay Per Click Advertising Generates Targeted Leads Thinking About Security Monitoring and Event Correlation Herpes zoster Choosing the ideal Limo Service Which Indoor Tanning Accessories Are For You Web Development Solutions Lead Management System The Talent Of Event-Triggered E-mail Triggers To Event Cardiomyopathy Wedding Limo Service Forget all those home tan products Pay Per Click (PPC) Management Internet Marketing Services Creating Custom Event Triggers In Task Scheduler Event Triggers Acromegaly Improve Cross-Selling To Customers With Event Triggered Marketing Event Handlers Archive for the Automated Emails, Event Trigger Marketing Category Web Designing Company Analytics Services Search Engine Marketing (SEM) Strategies SEO Friendly web design competitive advantage Visitor Tracking Web Site Visitor Tracking Website Tracking System Real-Time Visitor Tracking System Website Traffic Statistics and Web Analytics	A trigger can be in one of two distinct modes: Enabled. An enabled trigger executes its trigger body if a triggering statement is entering and the trigger constraint (if any) evaluates to TRUE. Disabled. A disabled trigger does not execute its trigger body, even if a triggering statement is entered and the trigger restriction (if any) evaluates to TRUE. Enabling Triggers By default, a trigger is automatically enabled when it is created; however, it can later be disabled. After you have completed the task that required the trigger to be disabled, re-enable the trigger, so that it fires when appropriate. Enable a disabled trigger using the ALTER TRIGGER statement with the ENABLE option. To enable the disabled trigger named REORDER of the INVENTORY table, enter the following statement: ALTER TRIGGER Reorder ENABLE; All triggers defined for a specific table can be enabled with one statement using the ALTER TABLE statement with the ENABLE clause with the ALL TRIGGERS option. For example, to enable all triggers defined for the INVENTORY table, enter the following statement: ALTER TABLE Inventory ENABLE ALL TRIGGERS; Disabling Triggers You might provisionally immobilize a trigger if: An object it references is not nearby. You need to execute a large data load, and you want it to carry on quickly without firing triggers. You are reloading data. By default, triggers are enabling when first created. Bring to a halt a trigger using the ALTER TRIGGER statement with the DISABLE option. For example, to disable the trigger named REORDER of the INVENTORY table, enter the following statement: ALTER TRIGGER Reorder DISABLE; All triggers associated with a table can be disabling with one statement using the ALTER TABLE statement with the DISABLE section and the ALL TRIGGERS option. For example, to immobilize all triggers distinct for the INVENTORY table, enter the following statement: ALTER TABLE Inventory DISABLE ALL TRIGGERS; Viewing Information about Triggers The following data dictionary views make known information about triggers: USER_TRIGGERS ALL_TRIGGERS DBA_TRIGGERS The new column, BASE_OBJECT_TYPE, specifies whether the trigger is based on DATABASE, SCHEMA, table, or view. The old column, TABLE_NAME, is unacceptable if the base object is not table or view. The column ACTION_TYPE specifies whether the trigger is a call type activate or a PL/SQL trigger. The column TRIGGER_TYPE includes two additional values: BEFORE EVENT and AFTER EVENT, appropriate only to system events. The column TRIGGERING_EVENT includes all system and DML events.
Copyright © 2012 http://www.sagercorp.com