REM
REM Copyright (c) 2002, 2003, Oracle Corporation.  All rights reserved.  
REM
REM   Name
REM     cwm2awtr.sql
REM
REM   Description
REM     Truncates new cwm2 metadata tables in support of the
REM     analytical workspace create facility.
REM
REM     Should only need to be run if underlying structure of
REM     tables has changed from internal build/build such that
REM     previously created aw_load metadata would be incompatible
REM     with current software.
REM
REM   Notes
REM     Tables are new for Oracle 10i Release 1 and Oracle 9.2.0.2 release
REM
REM   MODIFIED  (MM/DD/YY)
REM    mstasiew   04/04/03 - mstasiew_txn106674
REM    mstasiew   03/25/03 - mstasiew_txn106708
REM    mstasiew   03/24/03 - 
REM    mstasiew   03/24/03 - 

delete from olapsys.CWM2$AWCubeCompPlan;
delete from olapsys.CWM2$AWCompSpecMembership;
delete from olapsys.CWM2$AWCompositeSpec;
delete from olapsys.CWM2$AWCubeLoadAggPlan;
delete from olapsys.CWM2$AWCubeAggMeasure;
delete from olapsys.CWM2$AWCubeAggLevel;
delete from olapsys.CWM2$AWCubeAgg;
delete from olapsys.CWM2$AWCubeLoadMeasure;
delete from olapsys.CWM2$AWCubeLoadFilter;
delete from olapsys.CWM2$AWCubeLoad;
delete from olapsys.CWM2$AWDimLoadFilter;
delete from olapsys.CWM2$AWDimLoad;
commit;
delete from OLAPSYS.CWM2$AWCompositeSpec;
delete from OLAPSYS.CWM2$AWCubeCompPlan;
delete from OLAPSYS.CWM2$AWCompSpecMembership;
delete from OLAPSYS.CWM2$AWCubeLoadAggPlan;
delete from OLAPSYS.CWM2$AWCubeAggMeasure;
delete from OLAPSYS.CWM2$AWCubeAggLevel;
delete from OLAPSYS.CWM2$AWCubeAgg;
delete from OLAPSYS.CWM2$AWCubeLoadMeasure;
delete from OLAPSYS.CWM2$AWCubeLoadParmValue;
delete from OLAPSYS.CWM2$AWCubeLoadFilter;
delete from OLAPSYS.CWM2$AWCubeLoad;
delete from OLAPSYS.CWM2$AWDimLoadParmValue;
delete from OLAPSYS.CWM2$AWDimLoadFilter;
delete from OLAPSYS.CWM2$AWDimLoad;
delete from OLAPSYS.CWM2$AWCompositeSpec;
delete from OLAPSYS.CWM2$AWCompSpecMembership;
commit;