Rem
Rem $Header: gensvc_indexes.sql 24-aug-2005.14:06:15 yxie Exp $
Rem
Rem gensvc_indexes.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      gensvc_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    yxie        08/24/05 - yxie_bug-4535347
Rem    yxie        08/17/05 - Created
Rem

----------------------------------------------------------------
-- Service Pending/Past Jobs Details
----------------------------------------------------------------
ALTER TABLE MGMT_GENSVC_JOBS_DETAILS
  ADD CONSTRAINT MGMT_GENSVC_JOBS_DETAILS_PK
      PRIMARY KEY ( target_guid, operation_guid )
      USING INDEX STORAGE
            (FREELISTS 4)
            INITRANS 4;