rem ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ rem Delete some OWB objects from this target schema rem ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ begin declare procedure do_stmt(p_stmt varchar2) is begin execute immediate (p_stmt); exception when others then null; end do_stmt; begin begin do_stmt('drop table wb_rt_parameters'); do_stmt('drop table wb_rt_platform_config'); do_stmt('drop table wb_rt_seeded_strings'); do_stmt('drop table wb_rt_exceptions'); do_stmt('drop table wb_rt_postload_exceptions'); do_stmt('drop table wb_rt_time_src'); do_stmt('drop package owbxmltk'); do_stmt('drop package wb'); do_stmt('drop package wbrttime'); do_stmt('drop package wb_rt_mapaudit_util'); do_stmt('drop synonym wb_rt_mapaudit'); do_stmt('drop procedure wb_abort'); do_stmt('drop procedure wb_analyze_schema'); do_stmt('drop procedure wb_analyze_table'); do_stmt('drop procedure wb_compile_plsql'); do_stmt('drop procedure wb_disable_all_constraints'); do_stmt('drop procedure wb_disable_all_triggers'); do_stmt('drop procedure wb_disable_constraint'); do_stmt('drop procedure wb_disable_trigger'); do_stmt('drop procedure wb_enable_all_constraints'); do_stmt('drop procedure wb_enable_all_triggers'); do_stmt('drop procedure wb_enable_constraint'); do_stmt('drop procedure wb_enable_trigger'); do_stmt('drop procedure wb_olap_load_cube'); do_stmt('drop procedure wb_olap_load_dimension'); do_stmt('drop procedure wb_truncate_table'); do_stmt('drop procedure wb_xml_load'); do_stmt('drop function wb_cal_month_name'); do_stmt('drop function wb_cal_month_of_year'); do_stmt('drop function wb_cal_month_short_name'); do_stmt('drop function wb_cal_qtr'); do_stmt('drop function wb_cal_week_of_year'); do_stmt('drop function wb_cal_year'); do_stmt('drop function wb_cal_year_name'); do_stmt('drop function wb_date_from_julian'); do_stmt('drop function wb_day_name'); do_stmt('drop function wb_day_of_month'); do_stmt('drop function wb_day_of_week'); do_stmt('drop function wb_day_of_year'); do_stmt('drop function wb_day_short_name'); do_stmt('drop function wb_decade'); do_stmt('drop function wb_hour12'); do_stmt('drop function wb_hour12mi_ss'); do_stmt('drop function wb_hour24'); do_stmt('drop function wb_hour24mi_ss'); do_stmt('drop function wb_is_date'); do_stmt('drop function wb_is_number'); do_stmt('drop function wb_is_space'); do_stmt('drop function wb_julian_from_date'); do_stmt('drop function wb_mi_ss'); do_stmt('drop function wb_rt_is_platform_repository'); do_stmt('drop function wb_rt_platform_repository'); do_stmt('drop function wb_rt_version'); do_stmt('drop function wb_week_of_month'); do_stmt('drop function wb_xml_load_f'); exception when others then null; end; begin do_stmt('drop sequence wb_rt_month_seq'); do_stmt('drop sequence wb_rt_platform_properties_seq'); do_stmt('drop sequence wb_rt_quarter_seq'); do_stmt('drop sequence wb_rt_tempcons_seq'); do_stmt('drop sequence wb_rt_tempindex_seq'); do_stmt('drop sequence wb_rt_temptable_seq'); do_stmt('drop sequence wb_rt_week_seq'); do_stmt('drop sequence wb_rt_year_seq'); do_stmt('drop synonym name_addr'); do_stmt('drop package owb_match_merge'); do_stmt('drop procedure wb_olap_load_dimension_genuk'); do_stmt('drop function owbrtps_key_to_instance'); do_stmt('drop function owbrtps_key_to_version'); do_stmt('drop function owbrtps_key_to_version_string'); do_stmt('drop function wb_rt_integer_version_number'); do_stmt('drop function wb_rt_minimum_service_version'); do_stmt('drop table wb_rt_platform_properties'); exception when others then null; end; begin do_stmt('drop table WB_RT_VERSION_FLAG'); do_stmt('drop synonym ALL_RT_AUDIT_DEPLOYMENTS'); do_stmt('drop synonym ALL_RT_AUDIT_EXECUTIONS'); do_stmt('drop synonym ALL_RT_AUDIT_EXECUTION_PARAMS'); do_stmt('drop synonym ALL_RT_AUDIT_EXEC_FILES'); do_stmt('drop synonym ALL_RT_AUDIT_EXEC_MESSAGES'); do_stmt('drop synonym ALL_RT_AUDIT_LOCATIONS'); do_stmt('drop synonym ALL_RT_AUDIT_LOCATION_FILES'); do_stmt('drop synonym ALL_RT_AUDIT_LOCATION_MESSAGES'); do_stmt('drop synonym ALL_RT_AUDIT_MAP_RUNS'); do_stmt('drop synonym ALL_RT_AUDIT_MAP_RUN_ERRORS'); do_stmt('drop synonym ALL_RT_AUDIT_MAP_RUN_SOURCES'); do_stmt('drop synonym ALL_RT_AUDIT_MAP_RUN_TARGETS'); do_stmt('drop synonym ALL_RT_AUDIT_MAP_RUN_TRACE'); do_stmt('drop synonym ALL_RT_AUDIT_OBJECTS'); do_stmt('drop synonym ALL_RT_AUDIT_SCRIPT_FILES'); do_stmt('drop synonym ALL_RT_AUDIT_SCRIPT_MESSAGES'); do_stmt('drop synonym ALL_RT_AUDIT_SCRIPT_RUNS'); do_stmt('drop synonym ALL_RT_AUDIT_STEP_RUNS'); do_stmt('drop synonym ALL_RT_AUDIT_STEP_RUN_SOURCES'); do_stmt('drop synonym ALL_RT_AUDIT_STEP_RUN_TARGETS'); do_stmt('drop synonym ALL_RT_INSTALLATIONS'); do_stmt('drop synonym ALL_RT_LOCATIONS'); do_stmt('drop synonym ALL_RT_LOCATION_PARAMETERS'); do_stmt('drop synonym ALL_RT_OBJECTS'); do_stmt('drop synonym ALL_RT_TASKS'); do_stmt('drop synonym ALL_RT_TASK_PARAMETERS'); do_stmt('drop synonym INTERACTIONEXECUTE'); do_stmt('drop synonym INTERACTIONEXECUTEBUILD'); do_stmt('drop synonym OWBRTPS_KEY_TO_INSTANCE'); do_stmt('drop synonym OWBRTPS_KEY_TO_VERSION'); do_stmt('drop synonym OWBRTPS_KEY_TO_VERSION_STRING'); do_stmt('drop synonym OWBXMLTK'); do_stmt('drop synonym OWB_MATCH_MERGE'); do_stmt('drop synonym OWB_TIMESERIES'); do_stmt('drop synonym NAME_ADDR'); do_stmt('drop synonym OWB$CDC$GET_LAST_DAY_LB'); do_stmt('drop synonym OWB$CDC$GET_LAST_DAY_UB'); do_stmt('drop synonym OWB$CDC$GET_LAST_MONTH_LB'); do_stmt('drop synonym OWB$CDC$GET_LAST_MONTH_UB'); do_stmt('drop synonym OWB$CDC$GET_LAST_WEEK_LB'); do_stmt('drop synonym OWB$CDC$GET_LAST_WEEK_UB'); do_stmt('drop synonym OWB$CDC$GET_LATEST_UB'); do_stmt('drop synonym OWB$CDC$GET_TXNS_START_TIME'); do_stmt('drop synonym OWBRTPS_KEY_TO_INSTANCE'); do_stmt('drop synonym OWBRTPS_KEY_TO_VERSION'); do_stmt('drop synonym OWBRTPS_KEY_TO_VERSION_STRING'); do_stmt('drop synonym WB'); do_stmt('drop synonym WBRTTIME'); do_stmt('drop synonym WB_ABORT'); do_stmt('drop synonym WB_ANALYZE_SCHEMA'); do_stmt('drop synonym WB_ANALYZE_TABLE'); do_stmt('drop synonym WB_CAL_MONTH_NAME'); do_stmt('drop synonym WB_CAL_MONTH_OF_YEAR'); do_stmt('drop synonym WB_CAL_MONTH_SHORT_NAME'); do_stmt('drop synonym WB_CAL_QTR'); do_stmt('drop synonym WB_CAL_WEEK_OF_YEAR'); do_stmt('drop synonym WB_CAL_YEAR'); do_stmt('drop synonym WB_CAL_YEAR_NAME'); do_stmt('drop synonym WB_COMPILE_PLSQL'); do_stmt('drop synonym WB_DATE_FROM_JULIAN'); do_stmt('drop synonym WB_DAY_NAME'); do_stmt('drop synonym WB_DAY_OF_MONTH'); do_stmt('drop synonym WB_DAY_OF_WEEK'); do_stmt('drop synonym WB_DAY_OF_YEAR'); do_stmt('drop synonym WB_DAY_SHORT_NAME'); do_stmt('drop synonym WB_DECADE'); do_stmt('drop synonym WB_DISABLE_ALL_CONSTRAINTS'); do_stmt('drop synonym WB_DISABLE_ALL_TRIGGERS'); do_stmt('drop synonym WB_DISABLE_CONSTRAINT'); do_stmt('drop synonym WB_DISABLE_TRIGGER'); do_stmt('drop synonym WB_ENABLE_ALL_CONSTRAINTS'); do_stmt('drop synonym WB_ENABLE_ALL_TRIGGERS'); do_stmt('drop synonym WB_ENABLE_CONSTRAINT'); do_stmt('drop synonym WB_ENABLE_TRIGGER'); do_stmt('drop synonym WB_HOUR12'); do_stmt('drop synonym WB_HOUR12MI_SS'); do_stmt('drop synonym WB_HOUR24'); do_stmt('drop synonym WB_HOUR24MI_SS'); do_stmt('drop synonym WB_IS_DATE'); do_stmt('drop synonym WB_IS_NUMBER'); do_stmt('drop synonym WB_IS_SPACE'); do_stmt('drop synonym WB_JULIAN_FROM_DATE'); do_stmt('drop synonym WB_MI_SS'); do_stmt('drop synonym WB_OLAP_AW_GET_SOLVE_ID'); do_stmt('drop synonym WB_OLAP_AW_PRECOMPUTE'); do_stmt('drop synonym WB_OLAP_AW_REMOVE_SOLVE_ID'); do_stmt('drop synonym WB_OLAP_AW_SET_SOLVE_ID'); do_stmt('drop synonym WB_OLAP_LOAD_CUBE'); do_stmt('drop synonym WB_OLAP_LOAD_DIMENSION'); do_stmt('drop synonym WB_RT_CONCAT'); do_stmt('drop synonym WB_RT_CONSTANTS'); do_stmt('drop synonym WB_RT_CONVERSIONS'); do_stmt('drop synonym WB_RT_DP_CREATE_FKPARTITION'); do_stmt('drop synonym WB_RT_DP_CREATE_FKTABLES'); do_stmt('drop synonym WB_RT_DQ'); do_stmt('drop synonym WB_RT_GETERROR'); do_stmt('drop synonym WB_RT_GETERRORWITHNAME'); do_stmt('drop synonym WB_RT_GETPARTITIONPROPERTIES'); do_stmt('drop synonym WB_RT_EXCEPTIONS'); do_stmt('drop synonym WB_RT_GET_ELAPSED_TIME'); do_stmt('drop synonym WB_RT_GET_JOB_METRICS'); do_stmt('drop synonym WB_RT_GET_LAST_EXECUTION_TIME'); do_stmt('drop synonym WB_RT_GET_MAP_RUN_AUDIT_ID'); do_stmt('drop synonym WB_RT_GET_NUMBER_OF_ERRORS'); do_stmt('drop synonym WB_RT_GET_NUMBER_OF_WARNINGS'); do_stmt('drop synonym WB_RT_GET_PARENT_AUDIT_ID'); do_stmt('drop synonym WB_RT_GET_RETURN_CODE'); do_stmt('drop synonym WB_RT_GET_RUN_METRICS'); do_stmt('drop synonym WB_RT_GET_START_TIME'); do_stmt('drop synonym WB_RT_INTEGER_VERSION_NUMBER'); do_stmt('drop synonym WB_RT_IS_PLATFORM_REPOSITORY'); do_stmt('drop synonym WB_RT_MAPAUDIT'); do_stmt('drop synonym WB_RT_MAPAUDIT_UTIL'); do_stmt('drop synonym WB_RT_MAPAUDIT_UTIL_INVOKER'); do_stmt('drop synonym WB_RT_MINIMUM_SERVICE_VERSION'); do_stmt('drop synonym WB_RT_MODE'); do_stmt('drop synonym WB_RT_MODE_CNT'); do_stmt('drop synonym WB_RT_PATTERN_ANALYSIS'); do_stmt('drop synonym WB_RT_PLATFORM_REPOSITORY'); do_stmt('drop synonym WB_RT_PROFILE_SERVICE'); do_stmt('drop synonym WB_RT_SCRIPTPROCESSOR'); do_stmt('drop synonym WB_RT_STATE_VARIABLE'); do_stmt('drop synonym WB_RT_TASK_VARIABLE'); do_stmt('drop synonym WB_RT_TF_MAP_OPERATIONS'); do_stmt('drop synonym WB_RT_TRANSACTION_HANDLER'); do_stmt('drop synonym WB_RT_UPDATEPROPERTIES'); do_stmt('drop synonym WB_RT_VERSION'); do_stmt('drop synonym WB_RTU_TRANSACTION_HANDLER'); do_stmt('drop synonym WB_RTV_DP_BUS_ATTR_MAPS'); do_stmt('drop synonym WB_RTV_DP_BUS_COMPROWS'); do_stmt('drop synonym WB_RTV_DP_BUS_RULE_STATS'); do_stmt('drop synonym WB_RTV_DP_BUS_TABLE_STATS'); do_stmt('drop synonym WB_RTV_DP_COLUMNINFO'); do_stmt('drop synonym WB_RTV_DP_COLUMNSTATS'); do_stmt('drop synonym WB_RTV_DP_CONFIGSTATS'); do_stmt('drop synonym WB_RTV_DP_CONSTRAINTINFO'); do_stmt('drop synonym WB_RTV_DP_CONSTRAINTSTATS'); do_stmt('drop synonym WB_RTV_DP_DEBUG'); do_stmt('drop synonym WB_RTV_DP_DOMAINVALUES'); do_stmt('drop synonym WB_RTV_DP_ERRORHANDLER'); do_stmt('drop synonym WB_RTV_DP_FDVALUES'); do_stmt('drop synonym WB_RTV_DP_FKCARDINALITY'); do_stmt('drop synonym WB_RTV_DP_FKCONFIG'); do_stmt('drop synonym WB_RTV_DP_FKVALUES'); do_stmt('drop synonym WB_RTV_DP_FKVALUES_V'); do_stmt('drop synonym WB_RTV_DP_PARTITION_METADATA'); do_stmt('drop synonym WB_RTV_DP_PATTERNVALUES'); do_stmt('drop synonym WB_RTV_DP_RDNTVALUES'); do_stmt('drop synonym WB_RTV_DP_TABLEINFO'); do_stmt('drop synonym WB_RTV_DP_TABLESTATS'); do_stmt('drop synonym WB_TO_DATE'); do_stmt('drop synonym WB_TO_NUMBER'); do_stmt('drop synonym WB_TRUNCATE_TABLE'); do_stmt('drop synonym WB_WEEK_OF_MONTH'); do_stmt('drop synonym WB_XML_LOAD'); do_stmt('drop synonym WB_XML_LOAD_F'); exception when others then null; end; end; end; /