Rem
Rem $Header: amdpatch.sql 05-jul-2005.11:38:46 awesley Exp $
Rem
Rem amdpatch.sql
Rem
Rem Copyright (c) 2000, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      amdpatch.sql
Rem
Rem    DESCRIPTION
Rem      Upgrade existing OLAP Catalog schemas to 9.2.0.3.1 patch release
Rem
Rem    NOTES
Rem
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    awesley     07/05/05 - change display_name and plural_name to change displayname and pluralname
Rem    awesley     06/21/05 - change display name and plural name length 
Rem    dbardwel    05/10/05 - Fix bug 4350160 from Rae Burns
Rem    dbardwel    04/25/05 - Added index for performance
Rem    dbardwel    04/24/05 - Bug 3996129 need 3 new columns in refresh table
Rem    cdalessi    10/06/04 - Move validation to SYS 
Rem    cdalessi    07/27/04 - Creation

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

alter session set current_schema = olapsys;

Rem Add anything below this line that needs to be patched post 10.2 release


alter table olapsys.CwM2$Dimension modify (
    displayname varchar2(90),
    pluralname varchar2(90)
); 

alter table olapsys.CwM2$Level modify (
    displayname varchar2(90),
    pluralname varchar2(90)
); 

alter table olapsys.CwM2$Hierarchy modify (
    displayname varchar2(90)
); 

alter table olapsys.CwM2$DimensionAttribute modify (
    displayname varchar2(90)
); 

alter table olapsys.CwM2$LevelAttribute modify (
    displayname varchar2(90)
); 

alter table olapsys.CwM2$Cube modify (
    displayname varchar2(90)
); 

alter table olapsys.CwM2$Measure modify (
    displayname varchar2(90)
); 


Rem truncate metadata tables. They will be repopulated by mr_refresh
@@cwm2awtm.sql
@@amdrelod.sql

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

alter session set current_schema = sys;
execute sys.cwm2_olap_installer.Validate_CWM2_Install;