Rem
Rem $Header: catamd.sql 07-oct-2004.13:46:02 cdalessi Exp $
Rem
Rem catamd.sql
Rem
Rem Copyright (c) 2000, 2004, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      catamd.sql
Rem
Rem    DESCRIPTION
Rem      Install cwm/cwm2 lite repository.
Rem      Parameters for script are default and temporary tablespace names.
Rem
Rem    NOTES
Rem
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    cdalessi    10/06/04 - Move validation to SYS 
Rem    cdalessi    01/23/04 - Add sysaux move procedure loads
Rem    cdalessi    11/03/03 - fix banner
Rem    awesley     09/22/03 - 92041 to main
Rem    cdalessi    07/29/03 - Moving cwm2_olap_dbms_aw_lib to olapsys
Rem    cdalessi    01/14/03 - remove call to obsolete oneostab.sql
Rem    cdalessi    10/21/02 - cdalessi_txn104879
Rem    cdalessi    10/10/02 - 
Rem    awesley     05/15/02 - 
Rem    dbardwel    02/25/02 - alter current_schema back to sys at end of script
Rem    dbardwel    02/02/19 -Moved olapodm.sql to cwm2inst.sql
Rem    mrangwal    02/01/02 -Added call to olapodm.sql & rem dimlevgs factmvgs
Rem    dbardwel    02/02/18 - Need to move call to loading after OLAPSYS user is created
Rem    dbardwel    02/02/18 - Added cwm2user.sql as sys level script to add necessary permissions
Rem                           to the olapsys user for the 9i2 release
Rem    awesley     02/02/14 - Move cwm2 stuff to cwm2inst, add alter session set current schema 
Rem    cdalessi    02/06/02 -
Rem    mrangwal    02/01/02 - Added calls to dimlevgs.sql and factmvgs.sql
Rem    cdalessi    01/18/02 -
Rem    dbardwel    01/17/02 - need further grants for olapsys user
Rem    cdalessi    01/14/02 -
Rem    cdalessi    01/14/02 -
Rem    cdalessi    01/10/02 -
Rem    awesley     11/05/01 - Add cwm2
Rem    cdalessi    08/21/01 - .
Rem    cdalessi    06/27/01 - .
Rem    cdalessi    06/27/01 - .
Rem    dthompso    04/11/01 - B1716330: Add parameter for default temporary tab
Rem    dthompso    07/24/00 - Change connect internal to connect / as sysdba.
Rem    dthompso    07/07/00 - remove export table.
Rem    dallan      06/23/00 - Add parameter for tablespace name.
Rem    dthompso    06/09/00 - Single install script.
Rem    dthompso    06/01/00 - Add osa tables
Rem    dthompso    05/02/00 - Move package bodies to seperate script
Rem    dthompso    04/28/00 - Correct tables filename
Rem    dthompso    04/27/00 - Initial Version
Rem    dthompso    01/00/00 - Created
REM


@@amdsys &1 &2
@@onerole
@@cwm2user.sql

execute sys.dbms_registry.loading('AMD' ,'OLAP Catalog' ,'cwm2_olap_installer.Validate_CWM2_Install' ,'OLAPSYS'); 

alter session set current_schema = olapsys;

@@onetabs.sql
@@oneseed.sql
@@oneapi.sql
@@oneapigr.sql
@@oneapisy.sql
@@onevd.sql
@@onevdgrt.sql
@@onevdsyn.sql
@@oneva.sql
@@onevagrt.sql
@@onevasyn.sql
@@onemrv.sql
@@oneapib.sql

@@cwm2inst.sql

execute sys.dbms_registry.loaded('AMD');

alter session set current_schema = sys;

@@cwm2mov.pls
@@cwm2mov.plb
@@cwm2iner.pls
@@cwm2iner.plb

execute sys.cwm2_olap_installer.Validate_CWM2_Install;