Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\latest\group\group_triggers.sql
Rem drv: <create type="triggers" pos="ecm/ecm_triggers.sql+"/> Rem Rem $Header: group_triggers.sql 01-jul-2005.22:01:43 gsbhatia Exp $ Rem Rem group_triggers.sql Rem Rem Copyright (c) 2002, 2005, Oracle. All rights reserved. Rem Rem NAME Rem group_triggers.sql - <one-line expansion of the name> Rem Rem DESCRIPTION Rem <short description of component this file declares/defines> Rem Rem NOTES Rem <other useful comments, qualifications, etc.> Rem Rem MODIFIED (MM/DD/YY) Rem gsbhatia 07/01/05 - New repmgr header impl Rem gsbhatia 06/26/05 - New repmgr header impl Rem gsbhatia 02/13/05 - updating repmgr header Rem gsbhatia 02/09/05 - updating repmgr header Rem gsbhatia 02/07/05 - updating repmgr header Rem ktlaw 01/11/05 - add repmgr header Rem ramalhot 08/25/04 - cutover to new assoc tables Rem ramalhot 07/27/04 - code for target assoc added Rem streddy 10/15/03 - Check for group membership Rem streddy 10/09/03 - move metric dependency code from after trigger Rem to before trigger Rem streddy 09/25/03 - Added type_meta_ver for rep metrics Rem streddy 09/22/03 - Added flat memberships table Rem streddy 08/04/03 - Comment out group_history mgmt Rem streddy 06/30/03 - Add cluster membership association Rem streddy 04/22/03 - Support top-down membership composition Rem streddy 03/28/03 - Metric dependency changes for composites Rem rpatti 12/18/02 - fix perf Rem rpinnama 05/14/02 - rpinnama_reorg_rep_scripts Rem rpinnama 05/14/02 - Created Rem CREATE OR REPLACE TRIGGER memberships_insert_trigger INSTEAD OF INSERT ON MGMT_TARGET_MEMBERSHIPS FOR EACH ROW BEGIN em_assoc.insert_memberships(:new.composite_target_name, :new.composite_target_type, :new.composite_target_guid, :new.member_target_name, :new.member_target_type, :new.member_target_guid); END; / show errors;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de