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_report_favorites');
  exec('drop table owbb_navigation_favorites');
  exec('drop table owbb_group_repositories');
  exec('drop table owbb_user_repositories');
  exec('drop view owbb_repository_access_v');
  exec('drop table owbb_group_roles');
  exec('drop table owbb_user_roles');
  exec('drop view owbb_repositories_v');
  exec('drop view owbb_role_access_v');
  exec('drop table owbb_group_portlets'); 
  exec('drop table owbb_user_portlets'); 
	exec('drop table owbb_preferences');
	exec('drop table owbb_errors');
  exec('drop sequence owbb_repository_seq');
  exec('drop table owbb_repositories');
  exec('drop table owbb_administrators');
  exec('drop view owbb_repository_statuses_v');
  exec('drop view owbb_db_links_v');
  exec('drop view OWBB_ADMINISTRATORS_V');
  --lmm
  exec('drop table UIODREFERENCETABLE');
  exec('drop table UIODERRORTABLE');
  exec('drop table UIODREFERENCETARGETTABLE');
  exec('drop table OBJECTCONTEXTTREE');
  exec('drop table OBJECTHIERARCHYTABLE');
  exec('drop table HIERARCHYROOTS');
  exec('drop table HIERARCHYREFTABLE');
  
end;

end;