Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\reposasst\reposupgrade\release111\drop_apps_ddl.sql
begin declare procedure exec(p_stmt in varchar2) is begin execute immediate p_stmt; exception when others then dbms_output.put_line('===>' ||sqlcode || ' ' || sqlerrm); dbms_output.put_line(' ' || substr(p_stmt, 1, 250)); end; begin exec('drop table owbb_images'); exec('drop table owbb_role_queries'); exec('drop table owbb_queries'); exec('drop table owbb_design_queries'); exec('drop table owbb_role_reports'); exec('drop table owbb_reports'); exec('drop sequence owbb_report_seq'); exec('drop sequence owbb_favorites_seq'); exec('drop table owbb_type_icons'); exec('drop table owbb_type_bindings'); exec('drop table owbb_type_aliases'); exec('drop table owbb_types'); exec('drop table owbb_app_renderers'); exec('drop table owbb_app_repos_versions'); exec('drop table owbb_applications'); exec('drop sequence owbb_app_seq'); exec('drop table owbb_roles'); exec('drop table owbb_repos_types'); end; end;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de