Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\v102020\policy\policy

Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\core\v102020\policy\policy_indexes.sql

Rem
Rem $Header: policy_indexes.sql 03-aug-2005.08:04:22 niramach Exp $
Rem
Rem policy_indexes.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      policy_indexes.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    niramach    08/03/05 - niramach_bugfix-4527462
Rem    niramach    08/01/05 - Pulled the delta between beta and production   
Rem    gsbhatia    06/26/05 - New repmgr header impl 
Rem    rpinnama    06/07/05 - Add unique index on target type, policy name 
Rem    yaofeng     06/01/05 - add an index on mgmt_policy_assoc
Rem    niramach    08/01/05 - Created
Rem

SET ECHO ON
ALTER TABLE mgmt_policies
   ADD CONSTRAINT MGMT_policies_idx_02
       UNIQUE (target_type, policy_name)
       USING INDEX INITRANS 4;

Rem
Rem add an index on MGMT_POLICY_ASSOC table
Rem
CREATE INDEX mgmt_policy_assoc_idx1 ON 
     mgmt_policy_assoc(policy_type, policy_guid) COMPRESS 2;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de