shutdown trigger

[bensmail]

Hi all,
by abort shutdown, will the shutdown trigger fire???

Thank's all

[tycho]

According to Metalink it doesn't


Tycho

====================

The following example demonstrates how database event triggers can be used
to create and maintain an uptime log for the database.

CREATE TABLE up_time (action_date DATE, action VARCHAR2(20));

CREATE OR REPLACE TRIGGER db_start AFTER STARTUP ON DATABASE
BEGIN
insert into system.up_time values(sysdate,'STARTUP');
END;
/

CREATE OR REPLACE TRIGGER db_stop BEFORE SHUTDOWN ON DATABASE
BEGIN
insert into system.up_time values(sysdate,'SHUTDOWN');
END;
/

After creating these triggers, do the following:

SHUTDOWN IMMEDIATE
STARTUP
SHUTDOWN ABORT
STARTUP

The results are shown in the following up_time table:

ACTION_DATE ACTION
------------------ --------------------
27-AUG-98 12:22:40 SHUTDOWN
27-AUG-98 12:25:09 STARTUP
27-AUG-98 12:27:52 STARTUP

Notice that the SHUTDOWN ABORT is missing. Because of the nature of the
SHUTDOWN ABORT, the trigger does not fire.

[bensmail]

Thank's