Page Comparison

Column Drop Action

FDORA_COL_DROP_ACTION

No

Determines what action to take for "dropping" columns.

Can be set to SET UNUSED or DROP.

Defaults to SET UNUSED

Preview Execution

FDORA_PREVIEW_EXECUTION

No

Whether to bypass actual execution of the DDL, and simply run the compare.

Defaults to true.

For Pre-deploy workflow this should be checked to only run compare and generate report for review. In addition FDORA_OUT_CHANGES_EXIST output should be saved in FD_REVIEW_REQUIRED workflow output for Pre-deploy workflow and in addition FD_REVIEW_GROUP to assign Review tasks to specific group(s).

Automatically rollback changes if the deployment fails

FDORA_ROLLBACK_ON_FAIL

No

If a deployment failure occurs, should the database be rolled back to the previous state?

Defaults to false.

If true, the snapshot taken as the deployment starts will be rolled back to. If false, the database will be left in the state it is in after the first failure. The deployment stops after the first failure occurs.

Fail the workflow if it is rolled back successfully

FDORA_FAIL_AFTER_ROLLBACK

No

Added in 4.0.3.65.

If a deployment failure occurs, but it is successfully rolled back to the previous version, should the workflow still be failed?

Defaults to true.

Include Tablespaces

FDORA_TABLESPACE_FLG

No

Setting this to true causes create statements to include tablespace information where appropriate.  This adds the tablespace clause to all creates. Defaults to false.  Requires segments attributes to be enabled also.

Include Segment attributes

FDORA_SEGMENT_ATTRIBUTES_FLG

No

Setting this to true causes create statements to include tablespace segment attribute information where appropriate.  Defaults to false.

Include Storage

FDORA_STORAGE_FLG

No

Setting this to true causes create statements to include storage information where appropriate.  This adds the STOREAGE clause with its values on all creates. Defaults to false.    Requires segments attributes to be enabled also.