rem ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
prompt Find and fixup all of the runtime schema belonging to the source repository
prompt Update the version in each runtime schema
prompt Delete the WB_RT_% objects, since they are now supported by synonyms
rem ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

declare
begin

  begin
     execute immediate 'drop table wb_rt_parameters';      
     execute immediate 'drop table wb_rt_platform_config';      
     execute immediate 'drop table wb_rt_seeded_strings';      
     execute immediate 'drop table wb_rt_exceptions';      
     execute immediate 'drop table wb_rt_postload_exceptions';      
     execute immediate 'drop table wb_rt_time_src';      
     execute immediate 'drop package owbxmltk';
     execute immediate 'drop package wb';
     execute immediate 'drop package wbrttime';
     execute immediate 'drop package wb_rt_mapaudit_util';
     execute immediate 'drop synonym wb_rt_mapaudit';
     execute immediate 'drop procedure wb_abort';
     execute immediate 'drop procedure wb_analyze_schema';
     execute immediate 'drop procedure wb_analyze_table';
     execute immediate 'drop procedure wb_compile_plsql';
     execute immediate 'drop procedure wb_disable_all_constraints';
     execute immediate 'drop procedure wb_disable_all_triggers';
     execute immediate 'drop procedure wb_disable_constraint';
     execute immediate 'drop procedure wb_disable_trigger';
     execute immediate 'drop procedure wb_enable_all_constraints';
     execute immediate 'drop procedure wb_enable_all_triggers';
     execute immediate 'drop procedure wb_enable_constraint';
     execute immediate 'drop procedure wb_enable_trigger';
     execute immediate 'drop procedure wb_olap_load_cube';
     execute immediate 'drop procedure wb_olap_load_dimension';
     execute immediate 'drop procedure wb_truncate_table';
     execute immediate 'drop procedure wb_xml_load';

     execute immediate 'drop function wb_cal_month_name';
     execute immediate 'drop function wb_cal_month_of_year';
     execute immediate 'drop function wb_cal_month_short_name';
     execute immediate 'drop function wb_cal_qtr';
     execute immediate 'drop function wb_cal_week_of_year';
     execute immediate 'drop function wb_cal_year';
     execute immediate 'drop function wb_cal_year_name';
     execute immediate 'drop function wb_date_from_julian';
     execute immediate 'drop function wb_day_name';
     execute immediate 'drop function wb_day_of_month';
     execute immediate 'drop function wb_day_of_week';
     execute immediate 'drop function wb_day_of_year';
     execute immediate 'drop function wb_day_short_name';
     execute immediate 'drop function wb_decade';
     execute immediate 'drop function wb_hour12';
     execute immediate 'drop function wb_hour12mi_ss';
     execute immediate 'drop function wb_hour24';
     execute immediate 'drop function wb_hour24mi_ss';
     execute immediate 'drop function wb_is_date';
     execute immediate 'drop function wb_is_number';
     execute immediate 'drop function wb_is_space';
     execute immediate 'drop function wb_julian_from_date';
     execute immediate 'drop function wb_mi_ss';
     execute immediate 'drop function wb_rt_is_platform_repository';
     execute immediate 'drop function wb_rt_platform_repository';
     execute immediate 'drop function wb_rt_version';
     execute immediate 'drop function wb_week_of_month';
     execute immediate 'drop function wb_xml_load_f';
     execute immediate 'drop function wb_lookup_num';
     execute immediate 'drop function wb_lookup_char';


  exception
    when others
      then
          null;
  end;
      
  begin
     execute immediate 'drop sequence wb_rt_month_seq';
     execute immediate 'drop sequence wb_rt_platform_properties_seq';
     execute immediate 'drop sequence wb_rt_quarter_seq';
     execute immediate 'drop sequence wb_rt_tempcons_seq';
     execute immediate 'drop sequence wb_rt_tempindex_seq';
     execute immediate 'drop sequence wb_rt_temptable_seq';
     execute immediate 'drop sequence wb_rt_week_seq';
     execute immediate 'drop sequence wb_rt_year_seq';
     execute immediate 'drop synonym name_addr';
     execute immediate 'drop package owb_match_merge';
     execute immediate 'drop procedure wb_olap_load_dimension_genuk';
     execute immediate 'drop function owbrtps_key_to_instance';
     execute immediate 'drop function owbrtps_key_to_version';
     execute immediate 'drop function owbrtps_key_to_version_string';
     execute immediate 'drop function wb_rt_integer_version_number';
     execute immediate 'drop function wb_rt_minimum_service_version';
  exception
    when others
      then
          null;
  end;

end;
/