Rem
Rem Copyright (c) 2000, 2007, Oracle. All rights reserved.  
Rem

begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'VIEW' and
      object_name like 'ALL_RT%'
  )
  loop
    execute immediate 'drop view ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;

begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'VIEW' and
      object_name like 'RAB_RT%'
  )
  loop
    execute immediate 'drop view ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;

begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'VIEW' and
      object_name like 'WMP_RT_%'
  )
  loop
    execute immediate 'drop view ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;

begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'VIEW' and
      object_name like 'WB_RTV%'
  )
  loop
    execute immediate 'drop view ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;


begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'PACKAGE' and
      object_name like 'WB_RT%'
  )
  loop
    execute immediate 'drop package ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;

begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'FUNCTION' and
      object_name like 'WB_RT%'
  )
  loop
    execute immediate 'drop function ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop procedure service_available';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop function object_deployment_action';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop function object_deployment_status';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop function successful_object_deployment';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop function owbrtps_key_to_instance';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop function owbrtps_key_to_version';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop function owbrtps_key_to_version_string';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop package owb_client_values';
exception
  when others
  then
    null;
end;
/
commit;

begin
  execute immediate 'drop view wb_rtv_specified_user_values';
exception
  when others
  then
    null;
end;
/
commit;

begin
  delete from owbsys.raw_owbrepos where schemaname = user;
exception
  when others
  then
    null;
end;
/
commit;

begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'VIEW' and
      object_name like 'WB_RT%'
  )
  loop
    execute immediate 'drop view ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;