-- d:\d900\ck.ind
--
-- Generated for Oracle 8 on Wed May 27  13:45:12 1998 by Server Generator 2.1.20.0.0
  

PROMPT Creating Index 'CDI_VALID_PREFS_1'
CREATE UNIQUE INDEX CDI_VALID_PREFS_1 ON CDI_VALID_PREFS
 ( NLS_LANG
 , VP_DOMAIN
 , VP_VALUE )
/

PROMPT Creating Index 'RM$ASSERTIONS_PROPERTY'
CREATE INDEX RM$ASSERTIONS_PROPERTY ON RM$ASSERTIONS
 (PROPERTY)
/

PROMPT Creating Index 'RM$ASSERTIONS_SHORT_NAME'
CREATE INDEX RM$ASSERTIONS_SHORT_NAME ON RM$ASSERTIONS
 (SHORT_NAME)
/

PROMPT Creating Index 'RM$ASSERTIONS_SUPERTYPES'
CREATE INDEX RM$ASSERTIONS_SUPERTYPES ON RM$ASSERTIONS
 (SUPERTYPES)
/

PROMPT Creating Index 'RM$ASSERTIONS_MESSAGE_USAGE'
CREATE INDEX RM$ASSERTIONS_MESSAGE_USAGE ON RM$ASSERTIONS
 (MESSAGE_USAGE)
/

PROMPT Creating Index 'RM$ASSERTIONS_PRIME'
CREATE UNIQUE INDEX RM$ASSERTIONS_PRIME ON RM$ASSERTIONS
 (ID)
/

PROMPT Creating Index 'RM$ASSERTIONS_DEFINED_AGAINST'
CREATE INDEX RM$ASSERTIONS_DEFINED_AGAINST ON RM$ASSERTIONS
 (DEFINED_AGAINST)
/

PROMPT Creating Index 'RM$ASSERTIONS_EXPRESSION'
CREATE INDEX RM$ASSERTIONS_EXPRESSION ON RM$ASSERTIONS
 (EXPRESSION)
/

PROMPT Creating Index 'RM$ASSERTIONS_ID_FLAG'
CREATE INDEX RM$ASSERTIONS_ID_FLAG ON RM$ASSERTIONS
 (ID
 ,IS_UID_OR_ELM)
/

PROMPT Creating Index 'RM$ASSERTIONS_NAME'
CREATE INDEX RM$ASSERTIONS_NAME ON RM$ASSERTIONS
 (NAME)
/

PROMPT Creating Index 'RM$ASSERTIONS_OF_DOMAIN'
CREATE INDEX RM$ASSERTIONS_OF_DOMAIN ON RM$ASSERTIONS
 (OF_DOMAIN)
/

PROMPT Creating Index 'CD_FLAV_PRIME'
CREATE UNIQUE INDEX CD_FLAV_PRIME ON CDI_PRODUCT_FLAVOURS
 (P_SNAME
 ,P_CGVERSION
 ,SEQ)
/

PROMPT Creating Index 'REF_1'
CREATE UNIQUE INDEX REF_1 ON REF_VALUES
 (REF_DOMAIN
 ,REF_CODE
 ,REF_MEANING)
/

PROMPT Creating Index 'RM$VIOLATIONS_ACTIVITY'
CREATE INDEX RM$VIOLATIONS_ACTIVITY ON RM$VIOLATIONS
 (ACTIVITY)
/

PROMPT Creating Index 'RM$VIOLATIONS_ASSERTION'
CREATE INDEX RM$VIOLATIONS_ASSERTION ON RM$VIOLATIONS
 (ASSERTION)
/

PROMPT Creating Index 'RM$VIOLATIONS_ELEMENT'
CREATE INDEX RM$VIOLATIONS_ELEMENT ON RM$VIOLATIONS
 (ELEMENT)
/

PROMPT Creating Index 'RM$VIOLATIONS_PROPERTY'
CREATE INDEX RM$VIOLATIONS_PROPERTY ON RM$VIOLATIONS
 (PROPERTY)
/

PROMPT Creating Index 'RM$HASHES_CID'
CREATE UNIQUE INDEX RM$HASHES_CID ON RM$HASHES
 (CID
 ,HASH_VALUE
 ,EID)
/

PROMPT Creating Index 'RM$HASHES_EID'
CREATE UNIQUE INDEX RM$HASHES_EID ON RM$HASHES
 (EID
 ,CID
 ,HASH_VALUE)
/

PROMPT Creating Index 'CK_TEMP_COPY_EL_ID'
CREATE INDEX CK_TEMP_COPY_EL_ID ON CK_TEMP_COPY_EL_IDS
 (TRANS_REF
 ,ID)
/

PROMPT Creating Index 'CDRK_TMP_INDEX2'
CREATE INDEX CDRK_TMP_INDEX2 ON CDRK_TMP_TBL
 (OBJ_NAME
 ,OBJ_TYPE)
/

PROMPT Creating Index 'CDRK_TMP_INDEX1'
CREATE INDEX CDRK_TMP_INDEX1 ON CDRK_TMP_TBL
 (USERNAME
 ,OBJ_OWNER)
/

PROMPT Creating Index 'CK_LANG_KEY'
CREATE INDEX CK_LANG_KEY ON CK_LANGUAGE_PROPERTIES
 (LANGUAGE)
/

PROMPT Creating Index 'CK_LANG_PROP_PRIME'
CREATE UNIQUE INDEX CK_LANG_PROP_PRIME ON CK_LANGUAGE_PROPERTIES
 (LANGUAGE
 ,PROPERTY_NUMBER)
/

PROMPT Creating Index 'CDRF_TMP_INDEX1'
CREATE INDEX CDRF_TMP_INDEX1 ON CDRF_TMP_TBL
 (USERNAME
 ,OBJ_OWNER)
/

PROMPT Creating Index 'CDRF_TMP_INDEX2'
CREATE INDEX CDRF_TMP_INDEX2 ON CDRF_TMP_TBL
 (OBJ_NAME
 ,OBJ_TYPE)
/

PROMPT Creating Index 'CD_PROD_PRIME'
CREATE UNIQUE INDEX CD_PROD_PRIME ON CDI_PRODUCTS
 (SNAME
 ,VERSION)
/

PROMPT Creating Index 'NAV_TYPE'
CREATE INDEX NAV_TYPE ON CDI_NAV
 (NAV_TYPE)
/

PROMPT Creating Index 'NAV_PRIME'
CREATE UNIQUE INDEX NAV_PRIME ON CDI_NAV
 (NAV_BTNAME
 ,NAV_CNAME
 ,NAV_FNAME)
/

PROMPT Creating Index 'NAV_REF_BTNAME'
CREATE INDEX NAV_REF_BTNAME ON CDI_NAV
 (NAV_REF_BTNAME)
/

PROMPT Creating Index 'RM$DEFERRED_QUERIES_1'
CREATE INDEX RM$DEFERRED_QUERIES_1 ON RM$DEFERRED_QUERIES
 (ASSERTION
 ,ELEMENT)
/

PROMPT Creating Index 'RM$DEFERRED_QUERIES_ELEMENT'
CREATE INDEX RM$DEFERRED_QUERIES_ELEMENT ON RM$DEFERRED_QUERIES
 (ELEMENT)
/

PROMPT Creating Index 'RM$ACTIVITIES_PARENT'
CREATE INDEX RM$ACTIVITIES_PARENT ON RM$ACTIVITIES
 (PARENT)
/

PROMPT Creating Index 'RM$ACTIVITIES_CHILDREN'
CREATE INDEX RM$ACTIVITIES_CHILDREN ON RM$ACTIVITIES
 (CHILDREN)
/

PROMPT Creating Index 'RM$ACTIVITIES_OPEN_CHILD'
CREATE INDEX RM$ACTIVITIES_OPEN_CHILD ON RM$ACTIVITIES
 (OPEN_CHILD)
/

PROMPT Creating Index 'RM$ACTIVITIES_OPEN_PARENT'
CREATE INDEX RM$ACTIVITIES_OPEN_PARENT ON RM$ACTIVITIES
 (OPEN_PARENT)
/

PROMPT Creating Index 'CET_UK1'
CREATE INDEX CET_UK1 ON CI_ELEMENT_TYPES
 (EL_TYPE_OF
 ,ADDED_TYPE
 ,PRODUCT)
/

PROMPT Creating Index 'CET_PK'
CREATE INDEX CET_PK ON CI_ELEMENT_TYPES
 (SHORT_NAME
 ,PRODUCT)
/

PROMPT Creating Index 'CK_CKDBSZ_TBI2'
CREATE INDEX CK_CKDBSZ_TBI2 ON CK_CKDBSZ_TBI_TMP
 (REP_SEQ
 ,app_id
 ,TAB_ID
 ,DBU_ID
 ,OTB_ID
 ,ODB_ID)  
/


PROMPT Creating Index 'CK_CKDBSZ_TBI1'
CREATE INDEX CK_CKDBSZ_TBI1 ON CK_CKDBSZ_TBI_TMP
 (rep_seq,app_id,TBI_ID)
/

PROMPT Creating Index 'CDILANPRIME'
CREATE UNIQUE INDEX CDILANPRIME ON CDI_LANGUAGE_DEFINITIONS
 (LAN_NAME)
/

PROMPT Creating Index 'CK_CKDBSZ_DBU2'
CREATE INDEX CK_CKDBSZ_DBU2 ON CK_CKDBSZ_DBU_TMP
 (REP_SEQ
 ,app_id
 ,DBU_ID
 ,ODB_ID)
/

PROMPT Creating Index 'CK_CKDBSZ_DBU1'
CREATE INDEX CK_CKDBSZ_DBU1 ON CK_CKDBSZ_DBU_TMP
 (rep_seq, app_id, DBU_ID)
/

PROMPT Creating Index 'PIN_PRIME_CK_INSTALLED_OBJECTS'
CREATE INDEX PIN_PRIME_CK_INSTALLED_OBJECTS ON CK_INSTALLED_OBJECTS
 (CI_PIN_FLAG)
/

PROMPT Creating Index 'PRIME_CK_INSTALLED_OBJECTS'
CREATE UNIQUE INDEX PRIME_CK_INSTALLED_OBJECTS ON CK_INSTALLED_OBJECTS
 (CI_STAGE
 ,CI_TYPE
 ,CI_NAME)
/

PROMPT Creating Index 'RN_1'
CREATE UNIQUE INDEX RN_1 ON SDD_RESERVED_NAMES
 (RN_RES_NAME
 ,RN_TYPE)
/

prompt Creating Index 'ind_rn_object_irid_ivid'
create index ind_rn_object_irid_ivid on sdd_reserved_names
(rn_object_irid, rn_object_ivid)
/

PROMPT Creating Index 'TMP_PRIME'
CREATE INDEX TMP_PRIME ON CDI_TEMP_RPT_TABLES
 (TMP_SEQ
 ,TMP_PARAMNAME)
/

PROMPT Creating Index 'RM$DEFERRED_CHECKS_ASSERTION'
CREATE INDEX RM$DEFERRED_CHECKS_ASSERTION ON RM$DEFERRED_CHECKS
 (ASSERTION)
/

PROMPT Creating Index 'RM$DEFERRED_CHECKS_ELEMENT'
CREATE INDEX RM$DEFERRED_CHECKS_ELEMENT ON RM$DEFERRED_CHECKS
 (ELEMENT)
/

PROMPT Creating Index 'RM$DEFERRED_CHECKS_ID'
CREATE UNIQUE INDEX RM$DEFERRED_CHECKS_ID ON RM$DEFERRED_CHECKS
 (ID)
/

PROMPT Creating Index 'RM$DEFERRED_CHECKS_ACTIVITY'
CREATE INDEX RM$DEFERRED_CHECKS_ACTIVITY ON RM$DEFERRED_CHECKS
 (ACTIVITY)
/

PROMPT Creating Index 'CD_DFLT_PREF_PRIME'
CREATE UNIQUE INDEX CD_DFLT_PREF_PRIME ON CDI_DFLT_USER_PREF_USAGES
 (NLS_LANG
 ,P_SNAME
 ,P_CGVERSION
 ,PF_SEQ
 ,DUP_SNAME)
/

PROMPT Creating Index 'CDI_FRM_PRIME'
CREATE UNIQUE INDEX CDI_FRM_PRIME ON CDI_FORMS
 (FRM_FNAME)
/

PROMPT Creating Index 'CK_CKDBSZ_ODB1'
CREATE INDEX CK_CKDBSZ_ODB1 ON CK_CKDBSZ_ODB_TMP
 (REP_SEQ
 , app_id
  , odb_id)
/

PROMPT Creating Index 'RM$PATCHES_1'
CREATE UNIQUE INDEX RM$PATCHES_1 ON RM$PATCHES
 (PATCH_NAME
 ,INSTALLED_ON)
/

PROMPT Creating Index 'CK_TEMP_EL_TYPE_OF'
CREATE INDEX CK_TEMP_EL_TYPE_OF ON CK_TEMP_EL_IDS
 (TRANS_REF
 ,TYPE_OF)
/

PROMPT Creating Index 'CK_TEMP_EL_ID'
CREATE INDEX CK_TEMP_EL_ID ON CK_TEMP_EL_IDS
 (TRANS_REF
 ,EL_ID
 ,PASS)
/

PROMPT Creating Index 'CK_CKDBSZ_OTB1'
CREATE INDEX CK_CKDBSZ_OTB1 ON CK_CKDBSZ_OTB_TMP
 (rep_seq, app_id, ODB_ID)
/

PROMPT Creating Index 'TMP_DDL_TBL_PRIME'
CREATE UNIQUE INDEX TMP_DDL_TBL_PRIME ON CDDL_TMP_TBL
 (TMP_APPREF
 ,TMP_DBREF
 ,TMP_USERNAME
 ,TMP_ID)
/

PROMPT Creating Index 'CDITYMPRIME'
CREATE UNIQUE INDEX CDITYMPRIME ON CDI_TYPE_MATCH
 (TYPE_SHORT_NAME
 ,EL_TYPE_OF)
/

PROMPT Creating Index 'CD_DFLT_USAGE_PRIME'
CREATE UNIQUE INDEX CD_DFLT_USAGE_PRIME ON CDI_DFLT_USER_PREFS
 (P_SNAME
 ,P_CGVERSION
 ,SNAME)
/

PROMPT Creating Index 'CK_CKDBSZ_KEY2'
CREATE INDEX CK_CKDBSZ_KEY2 ON CK_CKDBSZ_KEY_TMP
 (ODB_ID
 ,OTB_ID
 ,REP_SEQ
 ,KEY_ID
,app_id)
/

PROMPT Creating Index 'CK_CKDBSZ_KEY1'
CREATE INDEX CK_CKDBSZ_KEY1 ON CK_CKDBSZ_KEY_TMP
 (rep_seq, app_id, KEY_ID)
/
