REM
REM Copyright (c) 2002, 2003, Oracle Corporation.  All rights reserved.  
REM
REM   Name
REM     cwm2awtm.sql
REM
REM   Description
REM     Truncates new cwm2 metadata refresh tables in support of
REM     migration and patch upgrades.
REM
REM     Should only need to be run during migrations and/or patch
REM     upgrades
REM
REM   Notes
REM
REM   MODIFIED  (MM/DD/YY)
REM    cdalessi  08/26/03 - cdalessi_txn108604 
REM    cdalessi  08/22/03 - Creation


truncate table cwm2$mrall_awviews;
truncate table cwm2$mrall_awviewcols;
truncate table cwm2$mrall_catalogs;
truncate table cwm2$mrall_catalog_entity_uses;
truncate table cwm2$mrall_listdims;
truncate table cwm2$mrall_dim_hiers;
truncate table cwm2$mrall_hierdims;
truncate table cwm2$mrall_dim_hier_level_uses;
truncate table cwm2$mrall_join_key_col_uses;
truncate table cwm2$mrall_dim_attributes;
truncate table cwm2$mrall_entity_desc_uses;
truncate table cwm2$mrall_descriptors;
truncate table cwm2$mrall_dim_level_attr_maps;
truncate table cwm2$mrall_cube_measures;
truncate table cwm2$mrall_facttblkeymaps;
truncate table cwm2$mrfacttblkeymaps;
truncate table cwm2$mrall_facttblfctmaps;
truncate table cwm2$mrfacttblfctmaps;
truncate table cwm2$mrall_hierdim_keycol_map;
truncate table cwm2$mrall_hier_custom_sort;
truncate table cwm2$mrall_olap2_agg_uses;
truncate table cwm2$mrall_cwm1_aggop;
truncate table cwm2$mrall_cwm1_aggord;

truncate table mrac_olap2_aws_t;
truncate table mrac_olap2_aw_map_dim_use_t;
truncate table mrac_olap2_aw_phys_obj_t;
truncate table mrac_olap2_aw_phys_obj_prop_t;
truncate table mrac_olap2_aw_map_meas_use_t;
truncate table mrac_olap2_aw_map_attr_use_t;
truncate table mrac_olap2_aw_dimensions_t;
truncate table mrac_olap2_aw_attributes_t;
truncate table mrac_olap2_aw_cubes_t;
truncate table mrac_olap2_aw_cube_dim_uses_t;
truncate table mrac_olap2_aw_dim_levels_t;
truncate table mrac_olap2_aw_cube_measures_t;
truncate table mrac_olap2_aw_cube_agg_specs_t;
truncate table mrac_olap2_aw_cube_agg_meas_t;
truncate table mrac_olap2_aw_cube_agg_lvl_t;
truncate table mrac_olap2_aw_cube_agg_op_t;
truncate table mrac_olap2_aw_hier_lvl_ord_t;