Rem
Rem $Header: cwm2drop.sql 18-nov-2003.13:10:14 awesley Exp $
Rem
Rem onedrop.sql
Rem
Rem Copyright (c) 2001, 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2drop.sql 
Rem
Rem    DESCRIPTION
Rem      Permenantly remove metadata by deleting 'OLAPSYS' schema.
Rem
Rem    NOTES
Rem      Must be run as 'SYS'. Does not remove OLAP_DBA_TABLES tablespace.
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem       awesley  11/18/03 - add verify_access ,export ,delete
Rem       dbardwel 09/23/03 - 
Rem    Aziz.Mboya  09/02/03 - amboya_txn108623. Code cleanup for package name change from cwm2_olap_aw_access to dbms_aw_utilities.
Rem    dbardwel    03/14/02 - Got rid of CONNECT / AS SYSDBA
Rem    Aziz.Mboya  01/29/02 - changed package name from cwm2_olap_awconvert to cwm2_olap_aw_access
Rem    dbardwel    01/24/02 - Add DBA$ and ALL$ 9i2 union view synonym drops
Rem    cdalessi    01/14/02 - Add missing entries.
Rem    awesley     11/08/01 - awesley_txn100648
Rem    awesley     11/06/01 - create
REM     mstasiew    01/31/02  mstasiew_txn101768
Rem    dbardwel    02/02/02 - Removed cwm_olap_map from this script 
Rem
  
rem
rem cwm2 API Package Synonyms
rem

drop public synonym cwm2_olap_exceptions
/
drop public synonym cwm2_olap_manager 
/
drop public synonym cwm2_olap_utility 
/
drop public synonym cwm2_olap_catalog
/
drop public synonym cwm2_olap_cube 
/
drop public synonym cwm2_olap_dimension 
/
drop public synonym cwm2_olap_dimension_attribute 
/
drop public synonym cwm2_olap_hierarchy 
/
drop public synonym cwm2_olap_level 
/
drop public synonym cwm2_olap_level_attribute 
/
drop public synonym cwm2_olap_measure 
/
drop public synonym cwm2_olap_validate 
/
drop public synonym cwm2_olap_verify_access
/
drop public synonym cwm2_olap_export 
/
drop public synonym cwm2_olap_delete
/
drop public synonym cwm2_olap_table_map
/
drop public synonym cwm2_olap_pc_transform 
/
drop public synonym cwm2_security
/
drop public synonym dbms_aw_utilities
/
drop public synonym all_olapmr_dimensions
/
drop public synonym all_olapmr_dim_attributes
/ 
drop public synonym all_olapmr_attributes
/
drop public synonym all_olapmr_dim_levels
/
drop public synonym cwm2_olap_classify
/

rem
rem DBA_OLAP view synonyms
rem

drop public synonym dba_olap2_cubes
/
drop public synonym dba_olap2_cube_measures
/
drop public synonym dba_olap2_cube_dim_uses
/
drop public synonym dba_olap2_cube_meas_dim_uses
/
drop public synonym dba_olap2_dimensions
/
drop public synonym dba_olap2_dim_hierarchies
/
drop public synonym dba_olap2_dim_levels
/
drop public synonym dba_olap2_dim_hier_level_uses
/
drop public synonym dba_olap2_dim_attributes
/
drop public synonym dba_olap2_dim_attr_uses
/
drop public synonym dba_olap2_dim_level_attributes
/
drop public synonym dba_olap2_cube_measure_maps
/
drop public synonym dba_olap2_fact_level_uses
/
drop public synonym dba_olap2_level_key_col_uses
/
drop public synonym dba_olap2_join_key_column_uses
/
drop public synonym dba_olap2_dim_level_attr_maps
/
drop public synonym dba_olap2_catalogs
/
drop public synonym dba_olap2_entity_desc_uses
/
drop public synonym dba_olap2_catalog_entity_uses
/
drop public synonym dba_olap2_fact_table_gid
/
drop public synonym dba_olap2_hier_custom_sort
/
drop public synonym dba_olapmr_facttblkeymaps
/
drop public synonym dba_olapmr_facttblfctmaps
/
drop public synonym dba_olap2_listdims
/
drop public synonym dba_olap2_dim_hiers
/
drop public synonym dba_olap2_hierdims
/
drop public synonym dba_olap2_FactTblKeyMaps
/
drop public synonym dba_olap2_rufcttblkyMaps
/
drop public synonym dba_olap2_FactTblFctMaps
/
drop public synonym dba_olap2_hierdim_keycol_map
/
drop public synonym dba_olapmr_dim_levels_keymaps
/
drop public synonym dba_olap2_dim_levels_keymaps
/
drop public synonym dba_olap2_mr_measdimview
/
drop public synonym dba_olap9i1_hier_dimensions
/
drop public synonym dba_olap9i2_hier_dimensions
/
drop public synonym dba_olap1_cubes
/
drop public synonym dba_olap2_entity_parameters
/
drop public synonym dba_olap2_entity_ext_parms
/

rem
rem ALL_OLAP view synonyms
rem

drop public synonym all_olap2_cubes
/
drop public synonym all_olap2_cube_measures
/
drop public synonym all_olap2_cube_dim_uses
/
drop public synonym all_olap2_cube_meas_dim_uses
/
drop public synonym all_olap2_dimensions
/
drop public synonym all_olap2_dim_hierarchies
/
drop public synonym all_olap2_dim_levels
/
drop public synonym all_olap2_dim_hier_level_uses
/
drop public synonym all_olap2_dim_attributes
/
drop public synonym all_olap2_dim_attr_uses
/
drop public synonym all_olap2_dim_level_attributes
/
drop public synonym all_olap2_cube_measure_maps
/
drop public synonym all_olap2_fact_level_uses
/
drop public synonym all_olap2_level_key_col_uses
/
drop public synonym all_olap2_join_key_column_uses
/
drop public synonym all_olap2_dim_level_attr_maps
/
drop public synonym all_olap2_catalogs
/
drop public synonym all_olap2_entity_desc_uses
/
drop public synonym all_olap2_catalog_entity_uses
/
drop public synonym all_olap2_fact_table_gid
/
drop public synonym all_olap2_hier_custom_sort
/
drop public synonym all_olapmr_facttblkeymaps
/
drop public synonym all_olapmr_facttblfctmaps
/
drop public synonym all_olap2_listdims
/
drop public synonym all_olap2_dim_hiers
/
drop public synonym all_olap2_hierdims
/
drop public synonym all_olap2_FactTblKeyMaps
/
drop public synonym all_olap2_rufcttblkyMaps
/
drop public synonym all_olap2_FactTblFctMaps
/
drop public synonym all_olap2_hierdim_keycol_map
/
drop public synonym all_olapmr_dim_levels_keymaps
/
drop public synonym all_olap2_dim_levels_keymaps
/
drop public synonym all_olap2_mr_measdimview
/
drop public synonym all_olap9i1_hier_dimensions
/
drop public synonym all_olap9i2_hier_dimensions
/
drop public synonym all_olap1_cubes
/
drop public synonym all_olap2_entity_parameters
/
drop public synonym all_olap2_entity_ext_parms
/