Rem
Rem $Header: cwm2inst.sql 11-feb-2005.12:25:42 awesley Exp $
Rem $Header: cwm2inst.sql 11-feb-2005.12:25:42 awesley Exp $
Rem
Rem oneinstl.sql
Rem
Rem Copyright (c) 2001, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      cwm2inst.sql
Rem
Rem    DESCRIPTION
Rem      Install cwm2 lite repository.
Rem      Parameters for script are default and temporary tablespace names.
Rem
Rem    NOTES
Rem
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem       awesley  02/11/05 - change olapodm.sql to olapodm.plb
Rem       dbardwel 09/13/04 - Remove cwm2conv.sql obsolete now.
Rem       cdalessi 01/21/04 - 
Rem       cdalessi 12/17/03 - Reload a few cwm1 objects the depend on
Rem                           modified cwm2 objects
Rem       dbardwel 12/05/03 - Moved cwm2vac.plb and cwm2conv.plb to end of this file.
Rem       awesley  12/05/03 - add cwm2expv.sql
Rem       dbardwel 10/08/03 - moved olap enabler sequence object to this file for 10g release
Rem                           Also removed cwm2enut as an installed file
Rem       dbardwel 09/23/03 - added cwm2sed3.sql
Rem       cdalessi 09/04/03 - change olapuser to apsroles
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 - rearrange and add trigger script
Rem    mrangwal    03/05/03 - Add olapodm.pls call
Rem    mrangwal    01/31/03 - Fix ordering of installation
Rem    dbardwel    02/04/03 - Correct installation ordering
Rem    cdalessi    12/30/02 - Add olapuser.sql call
Rem    mstasiew    11/25/02 -
Rem    amboya      10/17/02 - Add call to script for creating catalog for Custom Measures API
Rem    mstasiew    09/17/02 -
Rem    cdalessi    08/28/02 - Add call to cwm2vrq.sql
Rem    mstasiew    09/03/02 - grabtrans 'dbardwel_txn104107'
Rem    mstasiew    07/25/02 -
Rem    dbardwel    07/25/02 -
Rem    dbardwel    02/25/02 - Alter session and set current_schema back to sys at end of script
Rem    dbardwel    02/19/02 - Updates for MV scripts per mrangwal change
Rem    dbardwel    02/18/02 - Remove cwm2user.sql since this needs to be run as the
Rem                           SYS schema and cwm2inst.sql is run as the olapsys schema
Rem    awesley     02/02/14 - Add cwm2 stuff from oneinstl, add alter session set current schema
Rem    cdalessi    01/04/02 -
Rem    awesley     11/07/01 - awesley_txn100634
Rem    awesley     11/07/01 - Created
REM    mstasiew    11/20/01 - mstasiew_txn100734
REM    dbardwel    01/15/02 - dbardwel_txn101474
REM    dbardwel    01/24/02 - added cwm2upg.sql
REM

alter session set current_schema = olapsys;

REM
REM Need to alter CWM$CUBE to add the MVSUMMARYCODE
REM
alter table olapsys.cwm$cube add mvsummarycode varchar2(2);


REM
REM Create sequence object for tracking cwm2$ unique
REM key values
create sequence olap_IRID
    increment by 1
    start with 1
    nocycle
    nocache
    order;

REM
REM The OLAP Enabler sequence moved from file cwm2enut.pls
REM
create sequence olapsys.cwm2_olap_enableseq
    increment by 1
    start with 1
    minvalue 1
    maxvalue 9999
    cycle
    nocache
    order;

create sequence XML_LOADID_SEQUENCE;

@@cwm2mtbl.sql  -- cwm2 metadata tables
@@cwm2awcr.sql  -- new tables for AW_CREATE tracking metadata
@@cwm2pkfk.sql  -- cwm2 primary and foreign keys
@@cwm2trg.sql   -- cwm2 audit triggers
@@cwm2seed.sql  -- cwm2 seed metadata
@@cwm2api.sql   -- cwm2 package pls
@@cwm2apig.sql  -- cwm2 package grants
@@cwm2apis.sql  -- cwm2 package synonyms
@@onevacdu.sql
@@onevaceu.sql
@@onevaedu.sql
@@onevagrt.sql
@@onevasyn.sql
@@cwm2alvw.sql  -- cwm2 all views
@@cwm2grnt.sql  -- cwm2 all view grants
@@cwm2asyn.sql  -- cwm2 all view synonyms
@@cwm2dbvw.sql  -- cwm2 dba views
@@cwm2expv.sql  -- cwm2 export views
@@cwm2dgrt.sql  -- cwm2 dba view grants
@@cwm2dsyn.sql  -- cwm2 dba view synonyms
@@cwm2apib.sql  -- cwm2 package plb
@@cwm2upg.sql   -- upgrade from 9i
@@cwm2sed2.sql  -- new seed information for AW_CREATE tracking metadata
@@cwm2sed3.sql  -- new ODBO descriptors
@@cwm2awlv.sql
@@cwm2awlg.sql
@@cwm2awls.sql
@@cwm2awmd.sql

@@cwm2mrtb.sql  -- cwm2 metadata reader tables
@@cwm2mrv2.sql  -- cwm2 metadata reader views
@@cwm2mrgt.sql  -- cwm2 metadata reader view grants
@@cwm2mrsy.sql  -- cwm2 metadata reader view synonyms

@@cwm2mrat.sql  -- active catalog metadata refresh tables
@@cwm2mrav.sql  -- views
@@cwm2mrag.sql  -- grants
@@cwm2mras.sql  -- synonyms

@@cwm2mrsc.pls  -- cwm2 metadata reader security defs
@@cwm2mrrf.pls  -- cwm2 metadata reader refresh def
@@cwm2mrsc.plb  -- cwm2 metadata reader security impl
@@cwm2mrrf.plb  -- cwm2 metadata reader refresh impl
@@cwm2mrgp.sql  -- cwm2 metadata reader packages grants
@@cwm2mrss.sql  -- cwm2 metadata reader security synonyms

@@factvspc.sql
@@factview.sql
@@dimvwspc.sql
@@dimview.sql
@@olapodm.pls   -- Materialized view GS form
@@olapodm.plb   -- Materialized view GS form
@@cwm2vrq.sql

@@cwm2awao.sql  -- AW to PLSQL program interface enablement

@@cwm2awen.pls  -- cwm2_olap_olapapi_enable package specification
@@cwm2awen.plb  -- cwm2_olap_olapapi_enable package implementation
@@cwm2autl.pls  -- cwm2_olap_aw_utility
@@cwm2autl.plb  --
@@cwm2awct.pls  -- cwm2_olap_aw_create for 9.2.0.2.0
@@cwm2awct.plb  -- cwm2_olap_aw_create plsql binary
@@cwm2awcg.sql  -- grant script for aw create and enable packages
@@cwm2awcs.sql  -- synonym script for aw create and enable packages

@@cwm2cube.plb
@@cwm2vac.plb

@@apsroles.sql  -- olap_user role;

execute cwm2_olap_metadata_refresh.mr_refresh;

alter session set current_schema = sys;