using system event triggers

From: Josh Collier <Josh.Collier_at_Banfield.net>
Date: Thu, 26 Feb 2004 16:42:02 -0800
Message-ID: <219647973E94D211A8F20008C709725211D6B5C3@mercury.hq.vetsmart.com>

Is there a way to use a system event trigger to prevent completion of database open if a criteria isn't met  

some psuedo code to elaborate:  

CREATE OR REPLACE TRIGGER sys.post_dup_check

AFTER STARTUP ON DATABASE DECLARE db_name VARCHAR2 (50);

BEGIN db_name := ora_database_name;

IF db_name ! = ' whatever .WORLD'

then don't open

END IF; END; /

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Feb 26 2004 - 18:38:55 CST