...
| Input Name | Input Code | Required | Description |
|---|---|---|---|
| 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. |
FDORA_ROLLBACK_ON_FAIL | No | Added in 4.0.3.65. If a deployment failure occurs, should the database be rolled back to the previous state? Defaults to false. | |
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. |
Outputs
Output Name | Required | Description |
|---|---|---|
| No | This is the baseline ID currently deployed to the target environment OR the baseline ID created from this deployment. |
FDORA_OUT_NEW_BASELINE_ID | No | This is the baseline ID being deployed to this environment. |
FDORA_OUT_DELTA_BASELINE_ID | No | The ID to track the DDL used for this deployment. |
FDORA_OUT_DROP_TABLE_COUNT | No | Count of tables dropped. |
FDORA_OUT_CREATE_TABLE_COUNT | No | Count of tables created. |
FDORA_OUT_ALTER_TABLE_COUNT | No | Count of tables altered. |
FDORA_OUT_DROP_COLUMNS_COUNT | No | Count of columns dropped. |
FDORA_OUT_ADD_COLUMNS_COUNT | No | Count of columns added. |
FDORA_OUT_MODIFY_COLUMN_COUNT | No | Count of columns modified. |
FDORA_OUT_DROP_CONSTRAINT_COUNT | No | Count of constraints dropped. |
FDORA_OUT_ADD_CONSTRAINT_COUNT | No | Count of constraints added. |
FDORA_OUT_MODIFY_CONSTRAINT_COUNT | No | Count of constraints modified. |
FDORA_OUT_DROP_INDEX_COUNT | No | Count of indexes dropped. |
FDORA_OUT_CREATE_INDEX_COUNT | No | Count of indexes created. |
FDORA_OUT_ALTER_INDEX_COUNT | No | Count of indexes altered. |
FDORA_OUT_DROP_VIEW_COUNT | No | Count of views dropped. |
FDORA_OUT_CREATE_VIEW_COUNT | No | Count of views created. |
FDORA_OUT_ALTER_VIEW_COUNT | No | Count of views altered. |
FDORA_OUT_DROP_SEQUENCE_COUNT | No | Count of sequences dropped. |
FDORA_OUT_CREATE_SEQUENCE_COUNT | No | Count of sequences created. |
FDORA_OUT_ALTER_SEQUENCE_COUNT | No | Count of sequences altered. |
FDORA_OUT_DROP_PROCEDURE_COUNT | No | Count of procedures dropped. |
FDORA_OUT_CREATE_PROCEDURE_COUNT | No | Count of procedures created. |
FDORA_OUT_ALTER_PROCEDURE_COUNT | No | Count of procedures altered. |
FDORA_OUT_DROP_TRIGGER_COUNT | No | Count of triggers dropped. |
FDORA_OUT_CREATE_TRIGGER_COUNT | No | Count of triggers created. |
FDORA_OUT_ALTER_TRIGGER_COUNT | No | Count of triggered altered. |
FDORA_OUT_DROP_SYNONYM_COUNT | No | Count of synonyms dropped. |
FDORA_OUT_CREATE_SYNONYM_COUNT | No | Count of synonyms created. |
FDORA_OUT_DROP_FUNCTION_COUNT | No | Count of functions dropped. |
FDORA_OUT_CREATE_FUNCTION_COUNT | No | Count of functions created. |
FDORA_OUT_ALTER_FUNCTION_COUNT | No | Count of functions altered. |
FDORA_OUT_DROP_TYPE_COUNT | No | Count of types dropped. |
FDORA_OUT_CREATE_TYPE_COUNT | No | Count of types created. |
FDORA_OUT_ALTER_TYPE_COUNT | No | Count of types altered. |
FDORA_OUT_DROP_TYPE_BODY_COUNT | No | Count of type body drops. |
FDORA_OUT_CREATE_TYPE_BODY_COUNT | No | Count of type body creates. |
FDORA_OUT_ALTER_TYPE_BODY_COUNT | No | Count of type body alters. |
FDORA_OUT_DROP_PACKAGE_COUNT | No | Count of packages dropped. |
FDORA_OUT_CREATE_PACKAGE_COUNT | No | Count of packages created. |
FDORA_OUT_ALTER_PACKAGE_COUNT | No | Count of packages altered. |
FDORA_OUT_DROP_PACKAGE_BODY_COUNT | No | Count of package body drops. |
FDORA_OUT_CREATE_PACKAGE_BODY_COUNT | No | Count of package body creates. |
FDORA_OUT_ALTER_PACKAGE_BODY_COUNT | No | Count of package body alters. |
FDORA_OUT_DROP_MVIEW_COUNT | No | Count of materialized view drops. |
FDORA_OUT_CREATE_MVIEW_COUNT | No | Count of materialized view creates. |
FDORA_OUT_ALTER_MVIEW_COUNT | No | Count of materialized view alters. |
FDORA_OUT_DROP_MVIEW_LOG_COUNT | No | Count of materialized view log drops. |
FDORA_OUT_CREATE_MVIEW_LOG_COUNT | No | Count of materialized view log creates. |
FDORA_OUT_ALTER_MVIEW_LOG_COUNT | No | Count of materialized view log alters. |
FDORA_OUT_OBJECT_GRANT_COUNT | No | Count of object grants. |
FDORA_OUT_BL_TABLE_COUNT | No | Count of tables in the new baseline. |
FDORA_OUT_BL_INDEX_COUNT | No | Count of indexes in the new baseline. |
FDORA_OUT_BL_CONSTRAINT_COUNT | No | Count of constraints in the new baseline. |
FDORA_OUT_BL_SEQUENCE_COUNT | No | Count of sequences in the new baseline. |
FDORA_OUT_BL_PROCEDURES_COUNT | No | Count of procedures in the new baseline. |
FDORA_OUT_BL_VIEWS_COUNT | No | Count of views in the new baseline. |
FDORA_OUT_BL_SYNONYMS_COUNT | No | Count of synonyms in the new baseline. |
FDORA_OUT_BL_MVIEW_COUNT | No | Count of materialized views in the new baseline. |
FDORA_OUT_BL_MVIEW_LOG_COUNT | No | Count of materialized view logs in the new baseline. |
FDORA_OUT_RENAME_TABLE_COUNT | No | Count of table renames processed. |
FDORA_OUT_RENAME_COLUMN_COUNT | No | Count of column renames processed. |
FDORA_OUT_RENAME_CONSTRAINT_COUNT | No | Count of constraint renames processed. |
FDORA_OUT_RENAME_INDEX_COUNT | No | Count of index renames processed. |
FDORA_OUT_RENAME_VIEW_COUNT | No | Count of view renames processed. |
FDORA_OUT_RENAME_SEQUENCE_COUNT | No | Count of sequence renames processed. |
FDORA_OUT_RENAME_TRIGGER_COUNT | No | Count of trigger renames processed. |
FDORA_OUT_RENAME_SYNONYM_COUNT | No | Count of synonym renames processed. |
FDORA_OUT_BL_PRIVILEGES_COUNT | No | Count of object privileges in the new baseline. |
...