RE: using system event triggers

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Fri, 27 Feb 2004 08:24:51 -0500
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FEDAD5948@exchsen0a1ma>

Josh,  

This is a very bad idea. Even if you *could* do it, how in the world would you be able to fix it? If you cant start the database, then it's basically hosed.  

Just what are you trying to accomplish?  

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

From: Josh Collier [mailto:Josh.Collier_at_Banfield.net] Sent: Thursday, February 26, 2004 7:42 PM To: 'oracle-l_at_freelists.org'
Subject: using system event triggers

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 Fri Feb 27 2004 - 07:21:53 CST