Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\sql\wfengd.sql
REM $Header: wfengd.sql 26.0 2000/07/05 22:53:32 kma ship $ REM +=======================================================================+ REM | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA| REM | All rights reserved. | REM +=======================================================================+ REM REM NAME REM wfengd.sql - WorkFlow ENGine Drop objects REM DESCRIPTION REM Drops all objects associated with the Workflow Engine component REM USAGE REM sqlplus apps/apps @wfengd applsys fnd REM sqlplus apps/apps @wfengd apps apps REM +======================================================================+ REM Connect to base account REM (autopatch will run all scripts in apps account) connect &1/&2; REM Continue in case of error where constraints may not exist WHENEVER SQLERROR CONTINUE; -- Drop packages drop package WF_ACTIVITY_ATTRIBUTES_PKG; drop package WF_ACTIVITIES_PKG; drop package WF_ITEM_ACTIVITY_STATUS; drop package WF_ITEM; drop package WF_PROCESS_ACTIVITY; drop package WF_ACTIVITY; drop package WF_ENGINE; drop package WF_LOAD; drop package WF_PURGE; drop package WF_REPORT; drop package WF_STANDARD; drop package WF_MONITOR; -- Drop views drop view WF_ACTIVITIES_VL; drop view WF_ACTIVITY_ATTRIBUTES_VL; drop view WF_ITEM_ACTIVITY_STATUSES_V; -- Drop tables drop table WF_ACTIVITIES; drop table WF_ACTIVITIES_TL; drop table WF_ACTIVITY_ATTRIBUTES; drop table WF_ACTIVITY_ATTRIBUTES_TL; drop table WF_ACTIVITY_ATTR_VALUES; drop table WF_ACTIVITY_TRANSITIONS; drop table WF_ITEMS; drop table WF_ITEM_ATTRIBUTE_VALUES; drop table WF_ITEM_ACTIVITY_STATUSES; drop table WF_ITEM_ACTIVITY_STATUSES_H; drop table WF_PROCESS_ACTIVITIES; -- Drop sequences drop sequence WF_PROCESS_ACTIVITIES_S; drop sequence WF_ERROR_PROCESSES_S; -- Drop synonyms drop synonym WF_ACTIVITY_ATTRIBUTES_PKG; drop synonym WF_ACTIVITIES_PKG; drop synonym WF_ITEM_ACTIVITY_STATUS; drop synonym WF_ITEM; drop synonym WF_PROCESS_ACTIVITY; drop synonym WF_ACTIVITY; drop synonym WF_ENGINE; drop synonym WF_LOAD; drop synonym WF_PURGE; drop synonym WF_REPORT; drop synonym WF_STANDARD; drop synonym WF_ACTIVITIES_VL; drop synonym WF_ACTIVITY_ATTRIBUTES_VL; drop synonym WF_ITEM_ACTIVITY_STATUSES_V; drop synonym WF_ACTIVITIES; drop synonym WF_ACTIVITIES_TL; drop synonym WF_ACTIVITY_ATTRIBUTES; drop synonym WF_ACTIVITY_ATTRIBUTES_TL; drop synonym WF_ACTIVITY_ATTR_VALUES; drop synonym WF_ACTIVITY_TRANSITIONS; drop synonym WF_ITEMS; drop synonym WF_ITEM_ATTRIBUTE_VALUES; drop synonym WF_ITEM_ACTIVITY_STATUSES; drop synonym WF_ITEM_ACTIVITY_STATUSES_H; drop synonym WF_PROCESS_ACTIVITIES; drop synonym WF_PROCESS_ACTIVITIES_S; drop synonym WF_ERROR_PROCESSES_S; commit; exit;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de