Wfrmitms.sql
Use wfrmitms.sql to delete status information in Oracle Workflow runtime tables for a particular item. This script prompts you to choose between deleting all data associated with a specified item type and item key or deleting only data for the completed activities of the specified item type and item key.
Use the script as follows:
sqlplus <user/pwd> @wfrmitms <item_type> <item_key>
