What is a system event trigger?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is a system event trigger?
Rating:
A system event trigger is a database trigger defined on a system event. A system event trigger fires when a system event (such as startup, shutdown, logon, logoff, or error) occurs. Database triggers on system events can be defined at the database or schema level. For example, a trigger on database startup or shutdown can be defined only at the database level. However, a trigger on user logon or logoff can be defined at either the database level or schema level.
Database triggers can be created on the following system events:
| SERVERERROR | Causes the Oracle server to fire the trigger whenever a server error message is logged. |
| LOGON | Causes the Oracle server to fire the trigger whenever a user logs on to the database. |
| LOGOFF | Causes the Oracle server to fire the trigger whenever a user logs off the database. |
| STARTUP | Causes the Oracle server to fire the trigger whenever the database is opened. |
| SHUTDOWN | Causes the Oracle server to fire the trigger whenever the database is shut down. |
- The trigger on a SERVERERROR event can only be an AFTER trigger.
- The trigger on a LOGON event can only be an AFTER trigger.
- The trigger on a LOGOFF event can only be a BEFORE trigger.
- The trigger on a STARTUP event can only be an AFTER trigger.
- The trigger on a SHUTDOWN event can only be a BEFORE trigger.
Rating:
Was this information helpful?
Other articles
- What are conditional predicates?
- What is system privilege?
- What is PL/SQL?
- What is the REMOTE_DEPENDENCIES_MODE parameter?
- What is a bodiless package?