Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\misc\drop

Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\browserasst\misc\drop_objects.sql

declare
	procedure dyn_sql(p_sql in varchar2)
	is
	begin
		execute immediate p_sql;
	exception
		when others then
			return;
	end;

begin
		--|
		--|drop database links
		--|
/*
	begin
		for r in (select object_type, object_name from user_objects where object_type in ('DATABASE LINK') )
    loop
      dyn_sql('drop ' || r.object_type || ' ' || r.object_name);
		end loop;
	exception
		when others then
			return;
	end;	
*/
		--|
		--|drop synonyms
		--|
	dyn_sql('drop synonym wwnls_strings$');
	dyn_sql('drop synonym wwpob_style$');
	dyn_sql('drop synonym wwv_settingsdb');
        dyn_sql('drop synonym wwsec_app_priv');
        dyn_sql('drop synonym wwsec_person');
        dyn_sql('drop synonym wwsec_person$');
        dyn_sql('drop synonym wwsec_group$');
        dyn_sql('drop synonym wwv_utlglobl');
        dyn_sql('drop synonym wwv_standard_util');
	dyn_sql('drop synonym wwctx_api');
	dyn_sql('drop synonym wwsec_api');
	dyn_sql('drop synonym wwnls_api');
	dyn_sql('drop synonym wwerr_api_error');
	dyn_sql('drop synonym wwerr_api_error_ui');
	dyn_sql('drop synonym wwsto_api');
	dyn_sql('drop synonym wwpre_api_name');
	dyn_sql('drop synonym wwpre_api_value');
	dyn_sql('drop synonym wwlog_api');
	dyn_sql('drop synonym wwpro_api_provider');
	dyn_sql('drop synonym wwpro_api_parameters');
	dyn_sql('drop synonym wwpro_api_provider_registry');
	dyn_sql('drop synonym wwpob_api_page');
	dyn_sql('drop synonym wwpob_api_style');
	dyn_sql('drop synonym wwui_api_portlet');
	dyn_sql('drop synonym wwutl_htp');
	dyn_sql('drop synonym wwutl_htf');
        dyn_sql('drop synonym wwsec_api_private');
 	dyn_sql('drop synonym wwsec_group');
	dyn_sql('drop synonym wwsec_oid');
	dyn_sql('drop synonym wwsec_ui');
	dyn_sql('drop synonym wwsec_validation');
	dyn_sql('drop synonym wwv_setting');
	dyn_sql('drop synonym wwv_settingssets');
	dyn_sql('drop synonym WWPOB_APP_STYLE');

-- drop data profile package first, then sets, then types - gggraham (Bug 4283054)
  dyn_sql('drop package DATA_PROFILE_UTL');

-- drop data profile types and package - Ben
  -- moved to shiphome/owb/reposasst/drop_misc.sql - bloper
  -- unsure why dyn_sql() fails here??
  --dyn_sql('drop type profile_column_prop_set force');
  --dyn_sql('drop type profile_uk_prop_set force');
  --dyn_sql('drop type profile_fk_prop_set force');
  --dyn_sql('drop type profile_fd_prop_set force');
  --dyn_sql('drop type profile_rr_prop_set force');
  --dyn_sql('drop type profile_column_prop_type force');
  --dyn_sql('drop type profile_uk_prop_type force');
  --dyn_sql('drop type profile_fk_prop_type force');
  --dyn_sql('drop type profile_fd_prop_type force');
  --dyn_sql('drop type profile_rr_prop_type force');

-- drop data profile query types - gggraham
  -- moved to shiphome/owb/reposasst/drop_misc.sql - bloper
  -- unsure why dyn_sql() fails here??
  --dyn_sql('drop type profile_column_query_set force');
  --dyn_sql('drop type profile_uk_query_set force');
  --dyn_sql('drop type profile_fk_query_set force');
  --dyn_sql('drop type profile_fd_query_set force');
  --dyn_sql('drop type profile_rr_query_set force');
  --dyn_sql('drop type profile_column_query_type force');
  --dyn_sql('drop type profile_uk_query_type force');
  --dyn_sql('drop type profile_fk_query_type force');
  --dyn_sql('drop type profile_fd_query_type force');
  --dyn_sql('drop type profile_rr_query_type force');

--|
		--|drop packages and sequences
		--|

begin
		for r in (select object_type, object_name from user_objects where object_type in ('PACKAGE', 'SEQUENCE') and (object_name like 'WMP%' or object_name like 'LIA%' or object_name like 'OWBB%' ))
		loop
			dyn_sql('drop ' || r.object_type || ' ' || r.object_name);
		end loop;
	exception
		when others then
			return;
	end;

end;

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de