When you upgrade your database, use the Workflow Definitions Loader to preserve and back up your process definitions to a flat file. When the database upgrade is complete, use the Loader program again to upload the definitions back into your database. You can also use the Loader program to upgrade your database with a newer version of a process definition or to transfer process definitions to other databases.
The Workflow Definitions Loader program accepts several parameters that vary depending on the mode that you run the Loader program. Following is a summary of the Loader program's various modes and behavior.
Workflow Definitions Loader Behavior
|Mode||Data Transfer||Data Protected at Access Level Less Than Loader Access Level||Customized Data|
|UPGRADE||File to Database||Preserved||Preserved|
|UPLOAD||File to Database||Preserved||Overwritten|
|FORCE||File to Database||Overwritten||Overwritten|
|DOWNLOAD||Database to File||Not Applicable||Not Applicable|
|Table 1 - 2. (Page 1 of 1)|
To run the Workflow Definitions Loader for the version of Oracle Workflow embedded in Oracle Applications