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

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

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

begin
  for v in (
    select 
      object_name
    from
      user_objects
    where
      object_type = 'PROCEDURE' and
      object_name like 'WB_%'
  )
  loop
    execute immediate 'drop procedure ' || 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_%'
  )
  loop
    execute immediate 'drop function ' || v.object_name;
  end loop;
exception
  when others
  then
    null;
end;
/
commit;

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

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

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

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

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

begin
  execute immediate 'drop table OWB$$$_SOLVE_GROUP_IDS';
exception
  when others
  then
    null;
end;
/
commit;

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

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

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de