From oracle-l-bounce@freelists.org Thu Feb 26 18:38:55 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i1R0ctS04902 for ; Thu, 26 Feb 2004 18:38:55 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i1R0cso04897 for ; Thu, 26 Feb 2004 18:38:54 -0600 Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7D6FF39523D; Thu, 26 Feb 2004 19:40:08 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Thu, 26 Feb 2004 19:39:06 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from mercury.hq.vetsmart.com (unknown [63.91.53.90]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9AECC39515E for ; Thu, 26 Feb 2004 19:39:03 -0500 (EST) Received: by mercury.hq.vetsmart.com with Internet Mail Service (5.5.2656.59) id ; Thu, 26 Feb 2004 16:42:03 -0800 Message-ID: <219647973E94D211A8F20008C709725211D6B5C3@mercury.hq.vetsmart.com> From: Josh Collier To: "'oracle-l@freelists.org'" Subject: using system event triggers Date: Thu, 26 Feb 2004 16:42:02 -0800 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2656.59) Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3FCCA.84384760" X-archive-position: 2177 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Josh.Collier@Banfield.net Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l ------_=_NextPart_001_01C3FCCA.84384760 Content-Type: text/plain; charset="iso-8859-1" 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; / ------_=_NextPart_001_01C3FCCA.84384760 Content-Type: text/html; charset="iso-8859-1"
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;

/

------_=_NextPart_001_01C3FCCA.84384760-- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@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 -----------------------------------------------------------------