Rem Rem $Header: cwmlite/admin/catnoamd.sql /main/3 2009/03/18 10:26:53 awesley Exp $ Rem Rem catnoamd.sql Rem Rem Copyright (c) 2000, 2009, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem catnoamd.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 03/10/09 - add missing drops Rem - add second '@' to factvdrp.sql, dimvwdrp.sql, olapodrp.sql Rem cdalessi 10/21/02 - cdalessi_txn104879 Rem mrangwal 02/15/02 - Add olapodrp call Rem cdalessi 01/18/02 - Rem cdalessi 01/14/02 - Rem awesley 11/06/01 - Add cwm2 api Rem dthompso 07/24/00 - add connection. Rem dthompso 06/01/00 - Add new public synonyms for osa. Rem dthompso 04/27/00 - Initial Version Rem dthompso 01/00/00 - Created Rem rem rem drop cwm2 rem @@cwm2drop rem rem API Package Synonyms rem drop public synonym cwm_classify / drop public synonym cwm_exceptions / drop public synonym cwm_olap_cube / drop public synonym cwm_olap_measure / drop public synonym cwm_olap_dim_attribute / drop public synonym cwm_olap_dimension / drop public synonym cwm_olap_hierarchy / drop public synonym cwm_olap_level / drop public synonym cwm_olap_level_attribute / drop public synonym cwm_utility / rem rem DBA_OLAP view synonyms rem drop public synonym dba_olap_catalog_entity_uses / drop public synonym dba_olap_catalogs / drop public synonym dba_olap_columns / drop public synonym dba_olap_cube_dim_uses / drop public synonym dba_olap_cube_measure_dim_uses / drop public synonym dba_olap_cube_measure_maps / drop public synonym dba_olap_cube_measures / drop public synonym dba_olap_cubes / drop public synonym dba_olap_descriptor_types / drop public synonym dba_olap_descriptors / drop public synonym dba_olap_dim_attr_uses / drop public synonym dba_olap_dim_attributes / drop public synonym dba_olap_dim_hier_level_uses / drop public synonym dba_olap_dim_hierarchies / drop public synonym dba_olap_dim_level_attr_maps / drop public synonym dba_olap_dim_level_attributes / drop public synonym dba_olap_dim_levels / drop public synonym dba_olap_dimensions / drop public synonym dba_olap_entity_desc_uses / drop public synonym dba_olap_fact_level_uses / drop public synonym dba_olap_foreign_keys / drop public synonym dba_olap_function_arguments / drop public synonym dba_olap_function_parameters / drop public synonym dba_olap_function_usages / drop public synonym dba_olap_functions / drop public synonym dba_olap_join_key_column_uses / drop public synonym dba_olap_key_column_uses / drop public synonym dba_olap_keys / drop public synonym dba_olap_level_key_column_uses / drop public synonym dba_olap_tables / rem rem ALL_OLAP view synonyms rem drop public synonym all_olap_catalog_entity_uses / drop public synonym all_olap_catalogs / drop public synonym all_olap_columns / drop public synonym all_olap_cube_dim_uses / drop public synonym all_olap_cube_measure_dim_uses / drop public synonym all_olap_cube_measure_maps / drop public synonym all_olap_cube_measures / drop public synonym all_olap_cubes / drop public synonym all_olap_descriptor_types / drop public synonym all_olap_descriptors / drop public synonym all_olap_dim_attr_uses / drop public synonym all_olap_dim_attributes / drop public synonym all_olap_dim_hier_level_uses / drop public synonym all_olap_dim_hierarchies / drop public synonym all_olap_dim_level_attr_maps / drop public synonym all_olap_dim_level_attributes / drop public synonym all_olap_dim_levels / drop public synonym all_olap_dimensions / drop public synonym all_olap_entity_desc_uses / drop public synonym all_olap_fact_level_uses / drop public synonym all_olap_foreign_keys / drop public synonym all_olap_function_arguments / drop public synonym all_olap_function_parameters / drop public synonym all_olap_function_usages / drop public synonym all_olap_functions / drop public synonym all_olap_join_key_column_uses / drop public synonym all_olap_key_column_uses / drop public synonym all_olap_keys / drop public synonym all_olap_level_key_column_uses / drop public synonym all_olap_tables / drop package SYS.CWM2_OLAP_INSTALLER / drop public synonym ALL_AW_CUBE_AGG_LEVELS / drop public synonym ALL_AW_CUBE_AGG_MEASURES / drop public synonym ALL_AW_CUBE_AGG_PLANS / drop public synonym ALL_AW_CUBE_ENABLED_HIERCOMBO / drop public synonym ALL_AW_CUBE_ENABLED_VIEWS / drop public synonym ALL_AW_DIM_ENABLED_VIEWS / drop public synonym ALL_AW_LOAD_CUBES / drop public synonym ALL_AW_LOAD_CUBE_DIMS / drop public synonym ALL_AW_LOAD_CUBE_FILTERS / drop public synonym ALL_AW_LOAD_CUBE_MEASURES / drop public synonym ALL_AW_LOAD_CUBE_PARMS / drop public synonym ALL_AW_LOAD_DIMENSIONS / drop public synonym ALL_AW_LOAD_DIM_FILTERS / drop public synonym ALL_AW_LOAD_DIM_PARMS / drop public synonym ALL_LOAD_CUBE_SEGWIDTH / drop public synonym ALL_OLAP2_AGGREGATION_USES / drop public synonym ALL_OLAP2_AWVIEWCOLS / drop public synonym ALL_OLAP2_AWVIEWS / drop public synonym ALL_OLAP2_AW_ATTRIBUTES / drop public synonym ALL_OLAP2_AW_CATALOGS / drop public synonym ALL_OLAP2_AW_CATALOG_MEASURES / drop public synonym ALL_OLAP2_AW_CUBES / drop public synonym ALL_OLAP2_AW_CUBE_AGG_LVL / drop public synonym ALL_OLAP2_AW_CUBE_AGG_MEAS / drop public synonym ALL_OLAP2_AW_CUBE_AGG_OP / drop public synonym ALL_OLAP2_AW_CUBE_AGG_SPECS / drop public synonym ALL_OLAP2_AW_CUBE_DIM_USES / drop public synonym ALL_OLAP2_AW_CUBE_MEASURES / drop public synonym ALL_OLAP2_AW_DIMENSIONS / drop public synonym ALL_OLAP2_AW_DIM_HIER_LVL_ORD / drop public synonym ALL_OLAP2_AW_DIM_LEVELS / drop public synonym ALL_OLAP2_AW_PHYS_OBJ / drop public synonym ALL_OLAP2_AW_PHYS_OBJ_PROP / drop public synonym ALL_OLAP2_MV_CUBE_AGG_LEVELS / drop public synonym ALL_OLAP2_MV_CUBE_AGG_MEASURES / drop public synonym CWM2_OLAP_AW_AWUTIL / drop public synonym CWM2_OLAP_METADATA_REFRESH / drop public synonym CWM2_OLAP_MR_CHECK_PRIVS / drop public synonym CWM2_OLAP_MR_SECURITY_INIT / drop public synonym CWM2_OLAP_MR_SESSION_POP / drop public synonym CWM2_OLAP_OLAPAPI_ENABLE / drop public synonym DBA_OLAP2_AGGREGATION_USES / drop public synonym DBA_OLAP2_AWVIEWCOLS / drop public synonym DBA_OLAP2_AWVIEWS / drop public synonym DBMS_AWM / drop public synonym MRV_OLAP1_FACTTBLFCTMAPS / drop public synonym MRV_OLAP1_FACTTBLKEYMAPS / drop public synonym MRV_OLAP1_POP_CUBES / drop public synonym MRV_OLAP1_POP_DIMENSIONS / drop public synonym MRV_OLAP2_AGGREGATION_USES / drop public synonym MRV_OLAP2_AWS / drop public synonym MRV_OLAP2_AWVIEWCOLS / drop public synonym MRV_OLAP2_AWVIEWS / drop public synonym MRV_OLAP2_AW_ATTRIBUTES / drop public synonym MRV_OLAP2_AW_CUBES / drop public synonym MRV_OLAP2_AW_CUBE_AGG_LVL / drop public synonym MRV_OLAP2_AW_CUBE_AGG_MEAS / drop public synonym MRV_OLAP2_AW_CUBE_AGG_OP / drop public synonym MRV_OLAP2_AW_CUBE_AGG_SPECS / drop public synonym MRV_OLAP2_AW_CUBE_DIM_USES / drop public synonym MRV_OLAP2_AW_CUBE_MEASURES / drop public synonym MRV_OLAP2_AW_DIMENSIONS / drop public synonym MRV_OLAP2_AW_DIM_HIER_LVL_ORD / drop public synonym MRV_OLAP2_AW_DIM_LEVELS / drop public synonym MRV_OLAP2_AW_MAP_ATTR_USE / drop public synonym MRV_OLAP2_AW_MAP_DIM_USE / drop public synonym MRV_OLAP2_AW_MAP_MEAS_USE / drop public synonym MRV_OLAP2_AW_PHYS_OBJ / drop public synonym MRV_OLAP2_AW_PHYS_OBJ_PROP / drop public synonym MRV_OLAP2_CATALOGS / drop public synonym MRV_OLAP2_CATALOG_ENTITY_USES / drop public synonym MRV_OLAP2_CUBE_MEASURES / drop public synonym MRV_OLAP2_DESCRIPTORS / drop public synonym MRV_OLAP2_DIM_ATTRIBUTES / drop public synonym MRV_OLAP2_DIM_HIERS / drop public synonym MRV_OLAP2_DIM_HIER_LEVEL_USES / drop public synonym MRV_OLAP2_DIM_LEVEL_ATTR_MAPS / drop public synonym MRV_OLAP2_ENTITY_DESC_USES / drop public synonym MRV_OLAP2_ENTITY_EXT_PARMS / drop public synonym MRV_OLAP2_ENTITY_PARAMETERS / drop public synonym MRV_OLAP2_FACTTBLFCTMAPS / drop public synonym MRV_OLAP2_FACTTBLKEYMAPS / drop public synonym MRV_OLAP2_HIERDIMS / drop public synonym MRV_OLAP2_HIERDIMS_CC / drop public synonym MRV_OLAP2_HIERDIM_KEYCOL_MAP / drop public synonym MRV_OLAP2_HIER_CUSTOM_SORT / drop public synonym MRV_OLAP2_JOIN_KEY_COL_USES / drop public synonym MRV_OLAP2_LISTDIMS / drop public synonym MRV_OLAP2_LISTDIMS_CC / drop public synonym MRV_OLAP2_POP_CUBES / drop public synonym MRV_OLAP2_POP_DIMENSIONS / drop public synonym MRV_OLAP_CWM1_AGGOP / drop public synonym MRV_OLAP_CWM1_AGGORD / drop public synonym OLAP_SYS_AW_ACCESS_CUBE_VIEW / drop public synonym OLAP_SYS_AW_ACCESS_DIM_VIEW / drop public synonym OLAP_SYS_AW_ENABLE_ACCESS_VIEW / @@factvdrp.sql @@dimvwdrp.sql @@olapodrp.sql rem rem drop olapsys user rem drop user olapsys cascade / rem rem drop OLAP_DBA role rem drop role OLAP_DBA /