Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\create_rt_public

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\rtasst\create_rt_public_synonyms.sql

REM create public synonyms for ALL_RT_... public views and Control Center seeded transforms
begin
  execute immediate('create or replace public synonym all_rt_audit_deployments for owbsys.all_rt_audit_deployments');
  execute immediate('create or replace public synonym all_rt_audit_exec_files for owbsys.all_rt_audit_exec_files');
  execute immediate('create or replace public synonym all_rt_audit_exec_messages for owbsys.all_rt_audit_exec_messages');
  execute immediate('create or replace public synonym all_rt_audit_execution_params for owbsys.all_rt_audit_execution_params');
  execute immediate('create or replace public synonym all_rt_audit_executions for owbsys.all_rt_audit_executions');
  execute immediate('create or replace public synonym all_rt_audit_location_files for owbsys.all_rt_audit_location_files');
  execute immediate('create or replace public synonym all_rt_audit_location_messages for owbsys.all_rt_audit_location_messages');
  execute immediate('create or replace public synonym all_rt_audit_locations for owbsys.all_rt_audit_locations');
  execute immediate('create or replace public synonym all_rt_audit_map_run_errors for owbsys.all_rt_audit_map_run_errors');
  execute immediate('create or replace public synonym all_rt_audit_map_run_sources for owbsys.all_rt_audit_map_run_sources');
  execute immediate('create or replace public synonym all_rt_audit_map_run_targets for owbsys.all_rt_audit_map_run_targets');
  execute immediate('create or replace public synonym all_rt_audit_map_run_trace for owbsys.all_rt_audit_map_run_trace');
  execute immediate('create or replace public synonym all_rt_audit_map_runs for owbsys.all_rt_audit_map_runs');
  execute immediate('create or replace public synonym all_rt_audit_objects for owbsys.all_rt_audit_objects');
  execute immediate('create or replace public synonym all_rt_audit_proc_run_errors for owbsys.all_rt_audit_proc_run_errors');
  execute immediate('create or replace public synonym all_rt_audit_script_files for owbsys.all_rt_audit_script_files');
  execute immediate('create or replace public synonym all_rt_audit_script_messages for owbsys.all_rt_audit_script_messages');
  execute immediate('create or replace public synonym all_rt_audit_script_runs for owbsys.all_rt_audit_script_runs');
  execute immediate('create or replace public synonym all_rt_audit_step_run_sources for owbsys.all_rt_audit_step_run_sources');
  execute immediate('create or replace public synonym all_rt_audit_step_run_structs for owbsys.all_rt_audit_step_run_structs');
  execute immediate('create or replace public synonym all_rt_audit_step_run_targets for owbsys.all_rt_audit_step_run_targets');
  execute immediate('create or replace public synonym all_rt_audit_step_runs for owbsys.all_rt_audit_step_runs');
  execute immediate('create or replace public synonym all_rt_installations for owbsys.all_rt_installations');
  execute immediate('create or replace public synonym all_rt_location_parameters for owbsys.all_rt_location_parameters');
  execute immediate('create or replace public synonym all_rt_locations for owbsys.all_rt_locations');
  execute immediate('create or replace public synonym all_rt_objects for owbsys.all_rt_objects');
  execute immediate('create or replace public synonym all_rt_task_parameters for owbsys.all_rt_task_parameters');
  execute immediate('create or replace public synonym all_rt_tasks for owbsys.all_rt_tasks');

execute immediate('create or replace public synonym wb_rt_get_parent_audit_id for owbsys.wb_rt_get_parent_audit_id');
  execute immediate('create or replace public synonym wb_rt_get_job_metrics for owbsys.wb_rt_get_job_metrics');
  execute immediate('create or replace public synonym wb_rt_get_start_time for owbsys.wb_rt_get_start_time');
  execute immediate('create or replace public synonym wb_rt_get_elapsed_time for owbsys.wb_rt_get_elapsed_time');
  execute immediate('create or replace public synonym wb_rt_get_number_of_errors for owbsys.wb_rt_get_number_of_errors');
  execute immediate('create or replace public synonym wb_rt_get_number_of_warnings for owbsys.wb_rt_get_number_of_warnings');
  execute immediate('create or replace public synonym wb_rt_get_return_code for owbsys.wb_rt_get_return_code');
  execute immediate('create or replace public synonym wb_rt_get_map_run_audit_id for owbsys.wb_rt_get_map_run_audit_id');
  execute immediate('create or replace public synonym wb_rt_get_last_execution_time for owbsys.wb_rt_get_last_execution_time');

execute immediate('create or replace public synonym wb_rt_constants for owbsys.wb_rt_constants');
  execute immediate('create or replace public synonym wb_rt_conversions for owbsys.wb_rt_conversions');
  execute immediate('create or replace public synonym wb_rt_mapaudit for owbsys.wb_rt_mapaudit');
end;
/

REM create or replace public synonyms for WB_... public transformations
begin
  execute immediate('create or replace public synonym wb for owbsys.wb');
  execute immediate('create or replace public synonym wb_abort for owbsys.wb_abort');
  execute immediate('create or replace public synonym wb_analyze_schema for owbsys.wb_analyze_schema');
  execute immediate('create or replace public synonym wb_analyze_table for owbsys.wb_analyze_table');
  execute immediate('create or replace public synonym wb_cal_month_name for owbsys.wb_cal_month_name');
  execute immediate('create or replace public synonym wb_cal_month_of_year for owbsys.wb_cal_month_of_year');
  execute immediate('create or replace public synonym wb_cal_month_short_name for owbsys.wb_cal_month_short_name');
  execute immediate('create or replace public synonym wb_cal_qtr for owbsys.wb_cal_qtr');
  execute immediate('create or replace public synonym wb_cal_week_of_year for owbsys.wb_cal_week_of_year');
  execute immediate('create or replace public synonym wb_cal_year for owbsys.wb_cal_year');
  execute immediate('create or replace public synonym wb_cal_year_name for owbsys.wb_cal_year_name');
  execute immediate('create or replace public synonym wb_compile_plsql for owbsys.wb_compile_plsql');
  execute immediate('create or replace public synonym wb_date_from_julian for owbsys.wb_date_from_julian');
  execute immediate('create or replace public synonym wb_day_of_month for owbsys.wb_day_of_month');
  execute immediate('create or replace public synonym wb_day_of_week for owbsys.wb_day_of_week');
  execute immediate('create or replace public synonym wb_day_of_year for owbsys.wb_day_of_year');
  execute immediate('create or replace public synonym wb_day_name for owbsys.wb_day_name');
  execute immediate('create or replace public synonym wb_day_short_name for owbsys.wb_day_short_name');
  execute immediate('create or replace public synonym wb_decade for owbsys.wb_decade');
  execute immediate('create or replace public synonym wb_disable_all_constraints for owbsys.wb_disable_all_constraints');
  execute immediate('create or replace public synonym wb_disable_all_triggers for owbsys.wb_disable_all_triggers');
  execute immediate('create or replace public synonym wb_disable_constraint for owbsys.wb_disable_constraint');
  execute immediate('create or replace public synonym wb_disable_trigger for owbsys.wb_disable_trigger');
  execute immediate('create or replace public synonym wb_enable_all_constraints for owbsys.wb_enable_all_constraints');
  execute immediate('create or replace public synonym wb_enable_all_triggers for owbsys.wb_enable_all_triggers');
  execute immediate('create or replace public synonym wb_enable_constraint for owbsys.wb_enable_constraint');
  execute immediate('create or replace public synonym wb_enable_trigger for owbsys.wb_enable_trigger');
  execute immediate('create or replace public synonym wb_hour12 for owbsys.wb_hour12');
  execute immediate('create or replace public synonym wb_hour12mi_ss for owbsys.wb_hour12mi_ss');
  execute immediate('create or replace public synonym wb_hour24 for owbsys.wb_hour24');
  execute immediate('create or replace public synonym wb_hour24mi_ss for owbsys.wb_hour24mi_ss');
  execute immediate('create or replace public synonym wb_is_date for owbsys.wb_is_date');
  execute immediate('create or replace public synonym wb_is_number for owbsys.wb_is_number');
  execute immediate('create or replace public synonym wb_to_date for owbsys.wb_to_date');
  execute immediate('create or replace public synonym wb_to_number for owbsys.wb_to_number');
  execute immediate('create or replace public synonym wb_is_space for owbsys.wb_is_space');
  execute immediate('create or replace public synonym wb_julian_from_date for owbsys.wb_julian_from_date');
  execute immediate('create or replace public synonym wb_mi_ss for owbsys.wb_mi_ss');
  execute immediate('create or replace public synonym wb_truncate_table for owbsys.wb_truncate_table');
  execute immediate('create or replace public synonym wb_week_of_month for owbsys.wb_week_of_month');
  execute immediate('create or replace public synonym interactionexecutebuild for owbsys.interactionexecutebuild');
  --execute immediate('create or replace public synonym interactionexecute for owbsys.interactionexecute');
  --execute immediate('create or replace public synonym wb_olap_load_cube for owbsys.wb_olap_load_cube');
  execute immediate('create or replace public synonym wb_olap_load_dimension for owbsys.wb_olap_load_dimension');
  execute immediate('create or replace public synonym wb_olap_aw_precompute for owbsys.wb_olap_aw_precompute');
  execute immediate('create or replace public synonym wb_olap_aw_set_solve_id for owbsys.wb_olap_aw_set_solve_id');
  execute immediate('create or replace public synonym wb_olap_aw_get_solve_id for owbsys.wb_olap_aw_get_solve_id');
  execute immediate('create or replace public synonym wb_olap_aw_remove_solve_id for owbsys.wb_olap_aw_remove_solve_id');
  execute immediate('create or replace public synonym owb_timeseries for owbsys.owb_timeseries');

execute immediate('create or replace public synonym owbxmltk for owbsys.owbxmltk');
  execute immediate('create or replace public synonym wb_xml_load_f for owbsys.wb_xml_load_f');
  execute immediate('create or replace public synonym wb_xml_load for owbsys.wb_xml_load');

execute immediate('create or replace public synonym wb_lookup_num for owbsys.wb_lookup_num');
  execute immediate('create or replace public synonym wb_lookup_char for owbsys.wb_lookup_char');

end;
/

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de