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

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

Rem
Rem $Header: policy_indexes.sql 03-aug-2005.05:14:25 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/01/05 - Remove the change(delta) between beta and production 
Rem                           since it is moved to v102020. 
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    dkjain      04/15/05 - add index on mgmt_policy_assoc_eval_summ 
Rem    rpinnama    03/01/05 - rpinnama_bug-3924067
Rem    rpinnama    02/25/05 - Created
Rem

Rem
Rem Indices for MGMT_POLICY table
Rem
ALTER TABLE mgmt_policies
  ADD CONSTRAINT mgmt_policies_pk
    PRIMARY KEY (policy_guid);

CREATE INDEX mgmt_policies_idx_01
  ON mgmt_policies(metric_guid) ;

Rem
Rem Indices for MGMT_POLICY_PARAMETERS table
Rem
ALTER TABLE mgmt_policy_parameters
  ADD CONSTRAINT mgmt_policy_parameters_pk
    PRIMARY KEY(policy_guid, param_name);

Rem
Rem Indices for MGMT_POLICY_VIOL_CTXT_DEF table
Rem
ALTER TABLE mgmt_policy_viol_ctxt_def
  ADD  CONSTRAINT mgmt_policy_viol_ctxt_def_pk
    PRIMARY KEY(policy_guid, column_name);

Rem
Rem Indices for MGMT_POLICY_ASSOC_CFG table
Rem
ALTER TABLE mgmt_policy_assoc_cfg
  ADD  CONSTRAINT mgmt_policy_assoc_cfg_pk
    PRIMARY KEY(object_guid, policy_guid, coll_name, key_value, key_operator)
    USING INDEX ( CREATE INDEX mgmt_policy_assoc_cfg_pk_idx ON
                    mgmt_policy_assoc_cfg(object_guid, 
                                          policy_guid, 
                                          coll_name, 
                                          key_value, 
                                          key_operator,
                                          eval_order,
                                          is_exception,
                                          num_occurrences)
                 ) ;

Rem
Rem Indices for MGMT_POLICY_ASSOC_EVAL_SUMM table
Rem
ALTER TABLE mgmt_policy_assoc_eval_summ
  ADD  CONSTRAINT mgmt_policy_assoc_eval_summ_pk
    PRIMARY KEY(target_guid, policy_guid, coll_name);

CREATE INDEX mgmt_pol_asoc_eval_sum_idx_01
  ON mgmt_policy_assoc_eval_summ(policy_guid, target_guid);

Rem
Rem Indices for MGMT_POLICY_ASSOC_EVAL_DETAILS table
Rem
ALTER TABLE mgmt_policy_assoc_eval_details
  ADD CONSTRAINT mgmt_policy_assoc_eval_dtls_pk
    PRIMARY KEY(target_guid, policy_guid, coll_name, result_key_value);

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de