Rem
Rem Copyright (c) 2002, 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      apsu920.sql - migration script for upgrading olap aw component
Rem
Rem    DESCRIPTION
Rem      Migrate OLAP AW from 9.2.0
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    zqiu        04/30/08 - stacking upgrades
Rem    cchiappa    12/17/03 - Fix upgrade aw ver column problem
Rem    cdalessi    11/03/03 - fix banner 
Rem    cdalessi    08/20/03 - Add aps_validate call
Rem    cdalessi    01/22/03 - 10i completion of migration changes.
Rem    cdalessi    12/09/02 - 10i migration changes
Rem    cdalessi    10/18/02 - cdalessi_txn103996
Rem    cdalessi    10/14/02 - change to cataps
Rem    cdalessi    08/15/02 - Creation

execute sys.dbms_registry.upgrading('APS' ,'OLAP Analytic Workspace' ,'','');

UPDATE sys.aw$ SET version = 0 WHERE version IS NULL;

Rem In 9.2 we gave too many privileges to select_catalog_role.
BEGIN
 execute immediate 
   'REVOKE DELETE, INSERT, UPDATE ON DBA_AWS from select_catalog_role';
 execute immediate 
   'REVOKE DELETE, INSERT, UPDATE ON DBA_AW_PS from select_catalog_role';
EXCEPTION
  WHEN OTHERS THEN
    NULL;
END;
/

@@cataps

Rem
Rem Call 10.1 upgrade script
Rem
@@apsu101.sql

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

execute aps_validate;