Rem
Rem $Header: policy_indexes_downgrade.sql 03-aug-2005.08:04:22 niramach Exp $
Rem
Rem policy_indexes_downgrade.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      policy_indexes_downgrade.sql - Downgrade scripts for policy indexes 
Rem
Rem    DESCRIPTION
Rem      It has the creation of V1 policy indexes and removal of V2 policy indexes.
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    04/29/05 - niramach_bug-4293674
Rem    niramach    04/26/05 - Created
Rem

--Create V1 policy indexes that are obsolete in V2 10.2GC policy framework.
--Since it is downgrade, those V1 indexes should be created.
Rem
Rem Indices for MGMT_POLICY_VIOLATIONS table
Rem
CREATE INDEX MGMT_POLICY_VIOLATIONS_IDX1
    ON MGMT_POLICY_VIOLATIONS(RULE_ID, POLICY_ID, TARGET_GUID )
    COMPRESS 2;

CREATE INDEX MGMT_POLICY_VIOLATIONS_IDX2
    ON MGMT_POLICY_VIOLATIONS(TARGET_GUID, RULE_ID )
    COMPRESS 1;

--tbd:remove the V2 (10.2GC) policy indexes