- Dedication
- Preface
- I. DBA Tasks
- 1. Introduction
- 2. Installation
- 3. Maximizing Oracle Performance
- 4. Preventing Data Loss
- 5. Oracle Networking
- Oracle Names
- MultiProtocol Interchange
- Connecting to Non-Oracle Databases
- Network Manager Data Storage
- Using Network Manager
- Files Created by Network Manager
- Oracle Net8 Assistant
- Manual Network Configuration
- Sample SQL*Net Files
- SQL*Net Troubleshooting
- 6. Security and Monitoring
- 7. Auditing
- 8. Query Optimization
- 9. Oracle Tools
- 10. The Oracle Instance
- 11. The Oracle Database
- 12. Initialization Parameters
- 13. SQL Statements for the DBA
- SQL Commands by Task
- SQL Command Syntax
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- Reference Section
- column_constraint_clause
- auto_extend_clause
- for_clause
- filespec
- autoextend_clause
- global_index_clause
- local_index_clause
- table_constraint_clause
- table_ref_clause
- column_ref_clause
- column_constraint_clause
- index_organization_clause
- segment_attrib_clause
- partition_clause
- autoextend_clause
- 14. The Oracle Data Dictionary
- Static Data Dictionary Views
- Dynamic Performance Data Dictionary Views
- 15. System Privileges and Initial Roles
- 16. Tools and Utilities
Name
ALTER TRIGGER
Synopsis
ALTER TRIGGER [schema.]trigger_name[ENABLE | DISABLE] [COMPILE [DEBUG] ]
Enables or disables a database trigger (trigger_name).
Keywords
- ENABLE
Specifies that this trigger is to be fired when a triggering statement is issued.
- DISABLE
Specifies that this trigger is not to be fired when a triggering statement is issued.
- COMPILE
Specifies that the trigger is to be manually recompiled after it has become invalid.
- DEBUG
Specifies that the PL/SQL compiler is to generate information for use by the PL/SQL debugger.
Notes
You must own this trigger or have the ALTER ANY TRIGGER privilege to issue this command. Unlike other ALTER commands, the ALTER TRIGGER statement does not change the definition or structure of a trigger; this must be done with a CREATE OR REPLACE TRIGGER statement. Note that a trigger is automatically enabled when it is created. The ENABLE and DISABLE clauses of the ALTER TABLE statement may also be used to perform this function.
-
No Comment