Wfrmtype.sql
Use wfrmtype.sql to delete runtime data associated with a given item type. This script prompts you for an item type to purge, from a list of valid item type, then asks you to choose between deleting all data associated with a specified item type or deleting only data for the completed activities and items of the specified item type.
Use the script as follows:
sqlplus <user/pwd> @wfrmtype
