Rem drv: <migrate type="pre_data_upgrade" version="10.2.0.1" pos="gensvc/gensvc_post_creation.sql+"/>
Rem
Rem $Header: template_post_creation.sql 25-jul-2005.14:34:32 chyu Exp $
Rem
Rem template_post_creation.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      template_post_creation.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    chyu        07/25/05 - modifying the upgrade header 
Rem    chyu        07/18/05 - adding the upgrade header 
Rem    pmodi       07/14/05 - pmodi_bug-4486836
Rem    pmodi       07/13/05 - Created. File moved from v102010 to v102020
Rem                           for beta to production upgrade.
Rem

-- Add tables as a delete exception.
BEGIN
  DECLARE 
    del_exceptions SMP_EMD_STRING_ARRAY := SMP_EMD_STRING_ARRAY();
  BEGIN
    -- Add deletion exceptions here
    del_exceptions.extend(2);
    del_exceptions(1) := 'MGMT_TEMPLATE_COPIES';
    del_exceptions(2) := 'MGMT_MNTR_SET_COPIES';
    MGMT_ADMIN.add_target_deletion_exceptions(del_exceptions);
    COMMIT;
  END;
END;
/