Use wfrmitt.sql to delete all data in all Oracle Workflow design time and runtime tables for a particular item type. This script prompts you for an item type from a list of valid item types.
Use the script as follows:
sqlplus <user> @wfrmitt Enter password: <password>
Warning: This script deletes ALL workflow data for the specified item type.