Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\drop_rt_public_synonyms.sql
REM drop public synonyms for ALL_RT_... public views and Control Center seeded transforms begin execute immediate('drop public synonym all_rt_audit_deployments'); execute immediate('drop public synonym all_rt_audit_exec_files'); execute immediate('drop public synonym all_rt_audit_exec_messages'); execute immediate('drop public synonym all_rt_audit_execution_params'); execute immediate('drop public synonym all_rt_audit_executions'); execute immediate('drop public synonym all_rt_audit_location_files'); execute immediate('drop public synonym all_rt_audit_location_messages'); execute immediate('drop public synonym all_rt_audit_locations'); execute immediate('drop public synonym all_rt_audit_map_run_errors'); execute immediate('drop public synonym all_rt_audit_map_run_sources'); execute immediate('drop public synonym all_rt_audit_map_run_targets'); execute immediate('drop public synonym all_rt_audit_map_run_trace'); execute immediate('drop public synonym all_rt_audit_map_runs'); execute immediate('drop public synonym all_rt_audit_objects'); execute immediate('drop public synonym all_rt_audit_proc_run_errors'); execute immediate('drop public synonym all_rt_audit_script_files'); execute immediate('drop public synonym all_rt_audit_script_messages'); execute immediate('drop public synonym all_rt_audit_script_runs'); execute immediate('drop public synonym all_rt_audit_step_run_sources'); execute immediate('drop public synonym all_rt_audit_step_run_structs'); execute immediate('drop public synonym all_rt_audit_step_run_targets'); execute immediate('drop public synonym all_rt_audit_step_runs'); execute immediate('drop public synonym all_rt_installations'); execute immediate('drop public synonym all_rt_location_parameters'); execute immediate('drop public synonym all_rt_locations'); execute immediate('drop public synonym all_rt_objects'); execute immediate('drop public synonym all_rt_task_parameters'); execute immediate('drop public synonym all_rt_tasks'); execute immediate('drop public synonym wb_rt_get_parent_audit_id'); execute immediate('drop public synonym wb_rt_get_job_metrics'); execute immediate('drop public synonym wb_rt_get_start_time'); execute immediate('drop public synonym wb_rt_get_elapsed_time'); execute immediate('drop public synonym wb_rt_get_number_of_errors'); execute immediate('drop public synonym wb_rt_get_number_of_warnings'); execute immediate('drop public synonym wb_rt_get_return_code'); execute immediate('drop public synonym wb_rt_get_map_run_audit_id'); execute immediate('drop public synonym wb_rt_get_last_execution_time'); execute immediate('drop public synonym wb_rt_constants'); execute immediate('drop public synonym wb_rt_conversions'); execute immediate('drop public synonym wb_rt_mapaudit'); end; / begin execute immediate('drop public synonym wb'); execute immediate('drop public synonym wb_abort'); execute immediate('drop public synonym wb_analyze_schema'); execute immediate('drop public synonym wb_analyze_table'); execute immediate('drop public synonym wb_cal_month_name'); execute immediate('drop public synonym wb_cal_month_of_year'); execute immediate('drop public synonym wb_cal_month_short_name'); execute immediate('drop public synonym wb_cal_qtr'); execute immediate('drop public synonym wb_cal_week_of_year'); execute immediate('drop public synonym wb_cal_year'); execute immediate('drop public synonym wb_cal_year_name'); execute immediate('drop public synonym wb_compile_plsql'); execute immediate('drop public synonym wb_date_from_julian'); execute immediate('drop public synonym wb_day_of_month'); execute immediate('drop public synonym wb_day_of_week'); execute immediate('drop public synonym wb_day_of_year'); execute immediate('drop public synonym wb_day_name'); execute immediate('drop public synonym wb_day_short_name'); execute immediate('drop public synonym wb_decade'); execute immediate('drop public synonym wb_disable_all_constraints'); execute immediate('drop public synonym wb_disable_all_triggers'); execute immediate('drop public synonym wb_disable_constraint'); execute immediate('drop public synonym wb_disable_trigger'); execute immediate('drop public synonym wb_enable_all_constraints'); execute immediate('drop public synonym wb_enable_all_triggers'); execute immediate('drop public synonym wb_enable_constraint'); execute immediate('drop public synonym wb_enable_trigger'); execute immediate('drop public synonym wb_hour12'); execute immediate('drop public synonym wb_hour12mi_ss'); execute immediate('drop public synonym wb_hour24'); execute immediate('drop public synonym wb_hour24mi_ss'); execute immediate('drop public synonym wb_is_date'); execute immediate('drop public synonym wb_is_number'); execute immediate('drop public synonym wb_to_date'); execute immediate('drop public synonym wb_to_number'); execute immediate('drop public synonym wb_is_space'); execute immediate('drop public synonym wb_julian_from_date'); execute immediate('drop public synonym wb_mi_ss'); execute immediate('drop public synonym wb_truncate_table'); execute immediate('drop public synonym wb_week_of_month'); execute immediate('drop public synonym interactionexecutebuild'); --execute immediate('drop public synonym interactionexecute'); --execute immediate('drop public synonym wb_olap_load_cube'); execute immediate('drop public synonym wb_olap_load_dimension'); execute immediate('drop public synonym wb_olap_aw_precompute'); execute immediate('drop public synonym wb_olap_aw_set_solve_id'); execute immediate('drop public synonym wb_olap_aw_get_solve_id'); execute immediate('drop public synonym wb_olap_aw_remove_solve_id'); execute immediate('drop public synonym owb_timeseries'); execute immediate('drop public synonym owbxmltk'); execute immediate('drop public synonym wb_xml_load_f'); execute immediate('drop public synonym wb_xml_load'); execute immediate('drop public synonym wb_lookup_num'); execute immediate('drop public synonym wb_lookup_char'); end; /
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de