Mega Code Archive

 

Categories / Oracle PLSQL / Trigger

 

Trigger to log the database shutdown

SQL> SQL> CREATE TABLE uptime_log (   2      database_name       VARCHAR2(30),   3      event_name          VARCHAR2(20),   4      event_time          DATE,   5      triggered_by_user   VARCHAR2(30)   6      ); Table created. SQL> SQL> CREATE OR REPLACE TRIGGER log_shutdown   2  BEFORE SHUTDOWN ON DATABASE   3  BEGIN   4      INSERT INTO uptime_log   5          (database_name,   6           event_name,   7           event_time,   8           triggered_by_user)   9          VALUES (sys.database_name,  10                  sys.sysevent,  11                  sysdate,  12                  sys.login_user);  13      COMMIT;  14  END;  15  / Trigger created. SQL> SQL> drop table uptime_log; Table dropped. SQL> SQL> --