REM
REM Copyright (c) 2001, 2005, Oracle. All rights reserved.  
REM
REM   NAME
REM    cwm2pkfk.sql
REM
REM   DESCRIPTION
REM    File contains primary and foreign key constraint
REM    definitions for CWM2$ metadata tables.
REM
REM   NOTES
REM
REM    MODIFIED   (MM/DD/YY)
REM    dbardwel    04/24/05 - One additional index for bug 3996129
REM    awesley     12/06/04 - Bug 3996129 - add indexes to improve performance of fact mapping 
REM    awesley     12/19/03 - Add unique constraint cwm2$hiercustomsort_Name
REM    dbardwel    09/18/03 - Adding new FK constraint for cwm2$classificationvaluepair table
REM    awesley     09/23/03 - 92041 to main
REM    Aziz.Mboya  07/29/03 - Fix to bug 2998892: PROBLEMS WITH MAKCMCAT.SQL ORGANIZATION, amboya_txn108325
REM    dbardwel    06/23/03 - 
REM    cdalessi    04/28/03 - Separate triggers out to cwm2trg.sql
REM    dbardwel    10/24/01
REM

REM
REM All the Primary Keys
REM

ALTER TABLE CWM2$DIMENSION
 ADD (CONSTRAINT CWM2$DIMENSION_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$HIERARCHY
 ADD (CONSTRAINT CWM2$HIERARCHY_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$DIMENSIONATTRIBUTE
 ADD (CONSTRAINT CWM2$DIMENSIONATTRIBUTE_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$LEVEL
 ADD (CONSTRAINT CWM2$LEVEL_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$HIERLEVELREL
 ADD (CONSTRAINT CWM2$HIERLEVELREL_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$LEVELATTRIBUTE
 ADD (CONSTRAINT CWM2$LEVELATTRIBUTE_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$DIMHIERLVLMAP
 ADD (CONSTRAINT CWM2$DIMHIERLVLMAP_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$LEVELATTRIBUTEMAP
 ADD (CONSTRAINT CWM2$LEVELATTRIBUTEMAP_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$AW_DIMENSIONMAP
 ADD (CONSTRAINT CWM2$AW_DIMENSIONMAP_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$CUBE
 ADD (CONSTRAINT CWM2$CUBE_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$MEASURE
 ADD (CONSTRAINT CWM2$MEASURE_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$CUBEDIMENSIONUSE
 ADD (CONSTRAINT CWM2$CUBEDIMENSIONUSE_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$MEASURETABLEMAP
 ADD (CONSTRAINT CWM2$MEASURETABLEMAP_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$FACTDIMHIERMAP
 ADD (CONSTRAINT CWM2$FACTDIMHIERMAP_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$FACTDIMHIERTPLSDTL
 ADD (CONSTRAINT CWM2$FACTDIMHIERTPLSDTL_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$FACTKEYDIMHIERMAP
 ADD (CONSTRAINT CWM2$FACTKEYDIMHIERMAP_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$FACTKEYDIMHIERLVLMAP
 ADD (CONSTRAINT CWM2$FACTKEYDIMHIERLVLMAP_PK PRIMARY KEY
  (IRID))
/

ALTER TABLE CWM2$AW_MEASUREMAP
 ADD (CONSTRAINT CWM2$AW_MEASUREMAP_PK PRIMARY KEY
  (IRID))
/

alter table olapsys.cwm2$awviews
add (constraint cwm2$awviewpk primary key (irid))
/

ALTER TABLE OLAPSYS.CWM2$AWVIEWS
 ADD (CONSTRAINT CWM2$AWVIEWS_TBLUNQ
   UNIQUE(TABLE_ID))
/

ALTER TABLE OLAPSYS.CWM2$AWVIEWS
 ADD (CONSTRAINT CWM2$AWVIEWS_TBLUNQ2
   UNIQUE(VIEW_OWNER,
          VIEW_NAME))
/

REM
REM All the foreign keys
REM

ALTER TABLE CWM2$HIERARCHY ADD CONSTRAINT
 CWM2$HIERARCHY_DIM_FK FOREIGN KEY
  (DIMENSION_IRID) REFERENCES CWM2$DIMENSION
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$DIMENSIONATTRIBUTE ADD CONSTRAINT
 CWM2$DIMATTR_DIM_FK FOREIGN KEY
  (DIMENSION_IRID) REFERENCES CWM2$DIMENSION
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$LEVEL ADD CONSTRAINT
 CWM2$LEVEL_DIM_FK FOREIGN KEY
  (DIMENSION_IRID) REFERENCES CWM2$DIMENSION
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$HIERLEVELREL ADD CONSTRAINT
 CWM2$HIERLEVELREL_DIM_FK FOREIGN KEY
  (DIMENSION_IRID) REFERENCES CWM2$DIMENSION
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$HIERLEVELREL ADD CONSTRAINT
 CWM2$HIERLEVELREL_HIER_FK FOREIGN KEY
  (HIERARCHY_IRID) REFERENCES CWM2$HIERARCHY
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$HIERLEVELREL ADD CONSTRAINT
 CWM2$HIERLEVELREL_PLEVEL_FK FOREIGN KEY
  (PARENTLEVEL_IRID) REFERENCES CWM2$LEVEL
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$HIERLEVELREL ADD CONSTRAINT
 CWM2$HIERLEVELREL_CLEVEL_FK FOREIGN KEY
  (CHILDLEVEL_IRID) REFERENCES CWM2$LEVEL
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$LEVELATTRIBUTE ADD CONSTRAINT
 CWM2$LEVELATTR_DIM_FK FOREIGN KEY
  (DIMENSION_IRID) REFERENCES CWM2$DIMENSION
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$LEVELATTRIBUTE ADD CONSTRAINT
 CWM2$LEVELATTR_LEVEL_FK FOREIGN KEY
  (LEVEL_IRID) REFERENCES CWM2$LEVEL
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$LEVELATTRIBUTE ADD CONSTRAINT
 CWM2$LEVELATTR_DIMATTR_FK FOREIGN KEY
  (DIMATTR_IRID) REFERENCES CWM2$DIMENSIONATTRIBUTE
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$DIMHIERLVLMAP ADD CONSTRAINT
 CWM2$DIMHIERLVLMAP_DHL_FK FOREIGN KEY
 (DIMHIERLVL_IRID) REFERENCES CWM2$HIERLEVELREL
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$LEVELATTRIBUTEMAP ADD CONSTRAINT
 CWM2$LVLATTRMAP_HIERLVLREL_FK FOREIGN KEY
 (HIERLVLREL_IRID) REFERENCES CWM2$HIERLEVELREL
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$LEVELATTRIBUTEMAP ADD CONSTRAINT
 CWM2$LVLATTRMAP_LVLATTR_FK FOREIGN KEY
 (LEVELATTR_IRID) REFERENCES CWM2$LEVELATTRIBUTE
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$MEASURE ADD CONSTRAINT
 CWM2$MEASURE_CUBE_FK FOREIGN KEY
 (CUBE_IRID) REFERENCES CWM2$CUBE
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$CUBEDIMENSIONUSE ADD CONSTRAINT
 CWM2$CUBEDIMENSIONUSE_CUBE_FK FOREIGN KEY
 (CUBE_IRID) REFERENCES CWM2$CUBE
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$CUBEDIMENSIONUSE ADD CONSTRAINT
 CWM2$CUBEDIMENSIONUSE_DIM_FK FOREIGN KEY
 (DIMENSION_IRID) REFERENCES CWM2$DIMENSION
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$FACTDIMHIERMAP ADD CONSTRAINT
 CWM2$FACTDIMHIERMAP_CUBE_FK FOREIGN KEY
  (CUBE_IRID) REFERENCES CWM2$CUBE
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$FACTDIMHIERTPLSDTL ADD CONSTRAINT
 CWM2$FACTDIMHTD_CUBE_FK FOREIGN KEY
 (CUBE_IRID) REFERENCES CWM2$CUBE
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$FACTDIMHIERTPLSDTL ADD CONSTRAINT
 CWM2$FACTDIMHTD_FDHM_FK FOREIGN KEY
 (FACTDIMHIER_IRID) REFERENCES CWM2$FACTDIMHIERMAP
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$FACTKEYDIMHIERMAP ADD CONSTRAINT
 CWM2$FACTKEYDHM_FDHM_FK FOREIGN KEY
  (FACTDIMHIER_IRID) REFERENCES CWM2$FACTDIMHIERMAP
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$FACTKEYDIMHIERLVLMAP ADD CONSTRAINT
 CWM2$FACTKEYDHLM_FKDHM_FK FOREIGN KEY
  (FACTKEYDIMHIER_IRID) REFERENCES CWM2$FACTKEYDIMHIERMAP
  (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$MEASURETABLEMAP ADD CONSTRAINT
 CWM2$MEASURETABLEMAP_MEAS_FK FOREIGN KEY
 (MEASURE_IRID) REFERENCES CWM2$MEASURE
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$MEASURETABLEMAP ADD CONSTRAINT
 CWM2$MEASURETABLEMAP_FDHM_FK FOREIGN KEY
 (FACTDIMHIER_IRID) REFERENCES CWM2$FACTDIMHIERMAP
 (IRID) ON DELETE CASCADE
/

ALTER TABLE CWM2$CLASSIFICATIONVALUEPAIR ADD CONSTRAINT
 CWM2$CLASSVALUEPAIR_FK FOREIGN KEY
 (CLASSENTRY_IRID) REFERENCES CWM$CLASSIFICATIONENTRY
 (IRID) ON DELETE CASCADE
/

REM Create Primary Keys for the analytical workspace create facility tables

alter table OLAPSYS.CWM2$AWDimLoad
  ADD (Constraint CWM2$AWDimLoad_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWDimLoadFilter
  ADD (Constraint CWM2$AWDimLoadFilter_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWDimLoadParmValue
  ADD (Constraint CWM2$AWDimLoadParmValue_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWDimLoadParm
  ADD (Constraint CWM2$AWDimLoadParm_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWDimLoadType
  ADD (Constraint CWM2$AWDimLoadType_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoad
  ADD (Constraint CWM2$AWCubeLoad_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoadFilter
  ADD (Constraint CWM2$AWCubeLoadFilter_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoadParmValue
  ADD (Constraint CWM2$AWCubeLoadParmValue_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoadParm
  ADD (Constraint CWM2$AWCubeLoadParm_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoadType
  ADD (Constraint CWM2$AWCubeLoadType_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoadMeasure
  ADD (Constraint CWM2$AWCubeLoadMeasure_PK PRIMARY KEY
  (IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoadAggPlan
  ADD (Constraint CWM2$AWCubeLoadAggPlan_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeAgg
  ADD (Constraint CWM2$AWCubeAgg_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeAggLevel
  ADD (Constraint CWM2$AWCubeAggLevel_PK PRIMARY KEY
   (IRID))
/

alter table OLAPSYS.CWM2$AWCubeAggMeasure
  ADD (Constraint CWM2$AWCubeAggMeasure_PK PRIMARY KEY
   (IRID))
/


alter table OLAPSYS.CWM2$AWCompositeSpec
  ADD (Constraint CWM2$AWCompositeSpec_PK Primary KEY
  (IRID))
/

alter table OLAPSYS.CWM2$AWCompSpecMembership
  ADD (Constraint CWM2$AWCompSpecMembership_PK Primary KEY
  (IRID))
/

alter table OLAPSYS.CWM2$AWCubeCompPlan
  ADD (Constraint CWM2$AWCubeCompPlan_PK Primary KEY
  (IRID))
/

REM Unique key constraints

alter table OLAPSYS.CWM2$AWDimLoad
  ADD (Constraint CWM2$AWDimLoad_Name UNIQUE
   (Dim_IRID, Version_Id, Name))
/

alter table OLAPSYS.CWM2$AWDimLoadFilter
  ADD (Constraint CWM2$AWDimLoadFilter_ID UNIQUE
   (DimLoad_IRID, Lookup_Table_Owner, Lookup_Table_Name))
/

alter table OLAPSYS.CWM2$AWDimLoadParmValue
  ADD (Constraint CWM2$AWDimLoadParmValue_ID UNIQUE
   (DimLoad_IRID, ParmName_IRID))
/

alter table OLAPSYS.CWM2$AWCubeLoad
  ADD (Constraint CWM2$AWCubeLoad_Name UNIQUE
   (Cube_IRID, Version_Id, Name))
/

alter table OLAPSYS.CWM2$AWCubeLoadFilter
  ADD (Constraint CWM2$AWCubeLoadFilter_ID UNIQUE
   (CubeLoad_IRID, Fact_Table_Owner, Fact_Table_Name))
/

alter table OLAPSYS.CWM2$AWCubeLoadParmValue
  ADD (Constraint CWM2$AWCubeLoadParmValue_ID UNIQUE
   (CubeLoad_IRID, ParmName_IRID))
/

alter table OLAPSYS.CWM2$AWCubeAgg
  ADD (Constraint CWM2$AWCubeAgg_Name UNIQUE
   (Cube_IRID, Version_Id, Name))
/

alter table OLAPSYS.CWM2$AWCubeAggLevel
  ADD (Constraint CWM2$AWCubeAggLevel_ID UNIQUE
   (CubeAgg_IRID, Dim_IRID, Level_IRID))
/


alter table OLAPSYS.CWM2$AWCubeAggMeasure
  ADD (Constraint CWM2$AWCubeAggMeasure_ID UNIQUE
   (CubeAgg_IRID, Measure_IRID))
/


alter table OLAPSYS.CWM2$AWCompositeSpec
  ADD (Constraint CWM2$AWCompositeSpec_ID UNIQUE
   (Cube_IRID ,Version_Id, Name))
/


alter table OLAPSYS.CWM2$AWCompSpecMembership
  ADD (Constraint CWM2$AWCompSpecMembership_ID UNIQUE
   (CompSpec_IRID ,MemberType ,Name))
/


alter table OLAPSYS.CwM2$Dimension
  ADD Constraint    CwM2$Dimension_Name
    UNIQUE (Owner, Name)
/

alter table OLAPSYS.CwM2$DimensionAttribute
  ADD Constraint    CwM2$DimensionAttribute_Name
    UNIQUE (Dimension_IRID, Name)
/

alter table OLAPSYS.CwM2$Hierarchy
  ADD Constraint    CwM2$Hierarchy_Name
    UNIQUE (Dimension_IRID, Name)
/

alter table OLAPSYS.CwM2$Level
  ADD Constraint    CwM2$Level_Name
    UNIQUE (Dimension_IRID, Name)
/

alter table OLAPSYS.CwM2$LevelAttribute
  ADD Constraint    CwM2$LevelAttribute_Name
    UNIQUE (Level_IRID, Name)
/

alter table OLAPSYS.CwM2$Cube
  ADD Constraint    CwM2$Cube_Name
    UNIQUE (Owner, Name)
/

alter table OLAPSYS.CwM2$Measure
  ADD Constraint    CwM2$Measure_Name
    UNIQUE (Cube_IRID, Name)
/

alter table OLAPSYS.CwM2$AWCubeLoadMeasure
  ADD Constraint    CwM2$AWCubeLoadMeasure_Name
    UNIQUE (CubeLoad_IRID, Name)
/

alter table OLAPSYS.CwM2$AWCubeLoadAggPlan
  ADD Constraint    CwM2$AWCubeLoadAggPlan_Name
    UNIQUE (CubeLoad_IRID, CubeAgg_IRID)
/

alter table OLAPSYS.CwM2$AWCubeCompPlan
  ADD Constraint    CwM2$AWCubeCompPlan_Name
    UNIQUE (CubeLoad_IRID, CubeCompSpec_IRID)
/

alter table olapsys.cwm2$hiercustomsort
  ADD Constraint    cwm2$hiercustomsort_Name
    UNIQUE ( Tablename_ID ,Columnname_ID)
/


REM Foreign Key Constraints


alter table OLAPSYS.CWM2$AWDimLoadFilter ADD Constraint
  CWM2$AWDimLoadFilter_FK1 FOREIGN KEY
  (DIMLOAD_IRID) References OLAPSYS.CWM2$AWDimLoad
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWDimLoadParmValue ADD Constraint
  CWM2$AWDimLoadParmValue_FK1 FOREIGN KEY
  (DIMLOAD_IRID) References OLAPSYS.CWM2$AWDimLoad
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeLoadFilter ADD Constraint
  CWM2$AWCubeLoadFilter_FK1 FOREIGN KEY
  (CUBELOAD_IRID) References OLAPSYS.CWM2$AWCubeLoad
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeLoadParmValue ADD Constraint
  CWM2$AWCubeLoadParmValue_FK1 FOREIGN KEY
  (CUBELOAD_IRID) References OLAPSYS.CWM2$AWCubeLoad
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeLoadMeasure ADD Constraint
  CWM2$AWCubeLoadMeasure_FK FOREIGN KEY
  (CUBELOAD_IRID) References OLAPSYS.CWM2$AWCubeLoad
  (IRID) On Delete Cascade
/


alter table OLAPSYS.CWM2$AWCubeAggLevel ADD Constraint
  CWM2$AWCubeAggLevel_FK1 FOREIGN KEY
  (CUBEAGG_IRID) References OLAPSYS.CWM2$AWCubeAgg
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeAggMeasure ADD Constraint
  CWM2$AWCubeAggMeasure_FK1 FOREIGN KEY
  (CUBEAGG_IRID) References OLAPSYS.CWM2$AWCubeAgg
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeLoadAggPlan ADD Constraint
  CWM2$AWCubeLoadAggPlan_FK1 FOREIGN KEY
  (CUBELOAD_IRID) References OLAPSYS.CWM2$AWCubeLoad
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeLoadAggPlan ADD Constraint
  CWM2$AWCubeLoadAggPlan_FK2 FOREIGN KEY
  (CUBEAGG_IRID) References OLAPSYS.CWM2$AWCubeAgg
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCompSpecMembership ADD Constraint
  CWM2$AWCompSpecMembership_FK1 FOREIGN KEY
  (CompSpec_IRID) References OLAPSYS.CWM2$AWCompositeSpec
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCompSpecMembership ADD Constraint
  CWM2$AWCompSpecMembership_FK2 FOREIGN KEY
  (Composite_IRID) References OLAPSYS.CWM2$AWCompSpecMembership
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeCompPlan ADD Constraint
  CWM2$AWCubeCompPlan_FK1 FOREIGN KEY
  (CUBELOAD_IRID) References OLAPSYS.CWM2$AWCubeLoad
  (IRID) On Delete Cascade
/

alter table OLAPSYS.CWM2$AWCubeCompPlan ADD Constraint
  CWM2$AWCubeCompPlan_FK2 FOREIGN KEY
  (CUBECOMPSPEC_IRID) References OLAPSYS.CWM2$AWCompositeSpec
  (IRID) On Delete Cascade
/

-- bug 2967276
ALTER TABLE OLAPSYS.CWM2$FACTKEYDIMHIERMAP ADD CONSTRAINT
   CWM2$FACTKEYDIMHIERMAP_DIM_FK FOREIGN KEY
   (DIMENSION_IRID) REFERENCES OLAPSYS.CWM2$DIMENSION (IRID) 
   ON DELETE CASCADE
/
-- 123456789012345678901234567890
-- BUG 2639233
ALTER TABLE OLAPSYS.CWM2$FACTKEYDIMHIERLVLMAP ADD CONSTRAINT
   CWM2$FACTKEYD_H_L_MAP_LVL_FK FOREIGN KEY
   (LEVEL_IRID) REFERENCES OLAPSYS.CWM2$LEVEL (IRID) 
   ON DELETE CASCADE
/

-- BUG 2639233
ALTER TABLE OLAPSYS.CWM2$FACTKEYDIMHIERLVLMAP ADD CONSTRAINT
   CWM2$FACTKEYD_H_L_MAP_HIER_FK FOREIGN KEY
   (HIERARCHY_IRID) REFERENCES OLAPSYS.CWM2$HIERARCHY (IRID) 
   ON DELETE CASCADE
/

-- BUG 2639233
ALTER TABLE OLAPSYS.CWM2$FACTDIMHIERTPLSDTL ADD CONSTRAINT
   CWM2$FACTDIMH_TPLSDTL_HIER_FK FOREIGN KEY
   (HIER_IRID) REFERENCES OLAPSYS.CWM2$HIERARCHY (IRID) 
   ON DELETE CASCADE
/


CREATE INDEX OLAPSYS.CWM2$_CUST_MEAS_VIEW_NAME ON
    OLAPSYS.CWM2$_AW_NEXT_PERM_CUST_MEAS(AW_ACCESS_VIEW_NAME)
/


CREATE INDEX OLAPSYS.CWM2$_VIEW_AND_CUST_MEAS_COL ON
    OLAPSYS.CWM2$_AW_PERM_CUST_MEAS_MAP(AW_ACCESS_VIEW_NAME, CUST_ADT_COLUMN)
/


-- BUG 3996129
CREATE INDEX CWM2$FACTDIMHIERMAP_IC ON 
    OLAPSYS.CWM2$FACTDIMHIERMAP(CUBE_IRID) 
/

CREATE INDEX CWM2$FACTKEYDIMHIERMAP_IF ON 
    OLAPSYS.CWM2$FACTKEYDIMHIERMAP(FACTDIMHIER_IRID) 
/

CREATE INDEX CWM2$FACTKEYDIMHIERLVLMAP_IF ON 
    OLAPSYS.CWM2$FACTKEYDIMHIERLVLMAP(FACTKEYDIMHIER_IRID) 
/

CREATE INDEX CWM2$FACTDIMHIERTPLSDTL_IF ON 
    OLAPSYS.CWM2$FACTDIMHIERTPLSDTL(FACTDIMHIER_IRID) 
/

-- One more for BUG 3996129
create index cwm2$factdimhiertplsdtl_ih on olapsys.cwm2$FactDimHierTplsDtl (HIER_IRID)
/