Edit D:\app\Administrator\product\11.2.0\dbhome_1\owb\wf\demo\wfdemod.sql
/*=======================================================================+ | Copyright (c) 1995 Oracle Corporation Redwood Shores, California, USA| | All rights reserved. | +=======================================================================+ | FILENAME | wfdemod.sql | | DESCRIPTION | drop workflow Demonstration tables and packages | | NOTES | | MODIFIED 30-OCT-97 rseiden Added delete of demo users and roles from | wf_local_users, wf_local_roles, and | wf_local_user_roles. | MODIFIED 18-NOV-98 rseiden replaced user names with Vision database | compliant names according to: | JANDERSON => BLEWIS | MBEECH => CDOUGLAS | DMCKEE => KWALKER | JRUSH => SPIERSON | Removed user name JSMITH from demo. *=======================================================================*/ /* $Header: wfdemod.sql 26.0 2000/07/05 22:08:46 kma ship $ */ whenever sqlerror continue; drop package wf_demo; drop package wf_reqdemo; drop table WF_REQDEMO_EMP_HIERARCHY; drop table WF_REQDEMO_EMP_AUTHORITY; delete from wf_local_user_roles where role_name in ('ADMIN','MANAGERS','OTHERS','WORKERS'); delete from wf_local_users where name in ('SYSADMIN','WFADMIN','KWALKER','BLEWIS','SPIERSON','CDOUGLAS'); delete from wf_local_roles where name in ('ADMIN','MANAGERS','OTHERS','WORKERS'); exit;
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de