Rem drv: <create type="indexes"/>
Rem
Rem $Header: purge_indexes.sql 29-jun-2005.01:48:35 gsbhatia Exp $
Rem
Rem purge_indexes.sql
Rem
Rem Copyright (c) 2003, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      purge_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    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    scgrover    02/01/05 - compress index 
Rem    ktlaw       01/11/05 - add repmgr header 
Rem    rpinnama    09/08/03 - rpinnama_purge_policies 
Rem    rpinnama    09/08/03 - 
Rem    rpinnama    09/08/03 - 
Rem    rpinnama    09/05/03 - 
Rem    rpinnama    09/05/03 - Created
Rem

Rem
Rem Indices for MGMT_PURGE_POLICY table
Rem
ALTER TABLE MGMT_PURGE_POLICY
   ADD CONSTRAINT MGMT_PURGE_POLICY_PK
       PRIMARY KEY (policy_name)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;


Rem
Rem Indices for MGMT_PURGE_POLICY_GROUP table
Rem
ALTER TABLE MGMT_PURGE_POLICY_GROUP
   ADD CONSTRAINT MGMT_PURGE_POLICY_GROUP_PK
       PRIMARY KEY (group_name)
       USING INDEX STORAGE
                (FREELISTS 4)
                INITRANS 4;

Rem
Rem Indices for MGMT_PURGE_POLICY_TARGET_STATE table
Rem
ALTER TABLE MGMT_PURGE_POLICY_TARGET_STATE
   ADD CONSTRAINT MGMT_PURGE_POLICY_TGT_STATE_PK
       PRIMARY KEY (target_guid, policy_name)
       USING INDEX (CREATE UNIQUE INDEX MGMT_PURGE_POLICY_TGT_STATE_PK
                    ON MGMT_PURGE_POLICY_TARGET_STATE (target_guid, policy_name)
                    COMPRESS 1);