You can query or manually update the IN_DB_UPGRADE_CONTROL_UPGRADE table to view or change the default values used during the upgrade related procedures.
Note: You can also update the default upgrade parameters by
re-executing the UPGRADE_SETUP procedure using either the default values or by
specifying the desrired values for the respective parameters.
- To view the current parameter defaults, execute the following query.
SELECT * FROM INUSER.IN_DB_UPGRADE_CONTROL_UPGRADE;
- The following is an example of updating default values. Note:
Not all columns in this table should be modified. Updating some columns can lead to unintended behavior or prevent the package from functioning properly. Ensure to only update the following parameters as needed.
The values used in the following example are not the defaults in some cases. See the parameter descriptions for each procedure in the Synchronization and Upgrade Procedures section.
UPDATE INUSER.IN_DB_UPGRADE_CONTROL_UPGRADE SET SCHEMA_TARGET = '7.9.0.0' ,DEFAULT_MAX_MINUTES = 0 ,DEFAULT_PARALLEL = 4 ,DEFAULT_LOGGING = 'LOGGING'; COMMIT;