Synchronizes Oracle DDL to upgrade a schema to the supplied baseline.
Environment/Instance Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
| FDORA_URL | |||
| FDORA_USER | |||
| FDORA_PASSWORD | |||
| FDORA_DRIVER_PATH | |||
| FDORA_DDL_DRIVER_PATH | |||
| FDORA_SCHEMA_NAME | |||
| FDORA_OBJECT_TYPES | |||
| FDORA_DDL_URL | |||
| FDORA_DDL_USER | |||
| FDORA_DDL_PASSWORD |
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
| Column Drop Action | FDORA_COL_DROP_ACTION | Determines what action to take for "dropping" columns. | |
| Create Baseline | FDORA_CREATE_BASELINE_FLG | Whether to generate a baseline on the target environment and compare to new baseline. | |
| Preview Execution | FDORA_PREVIEW_EXECUTION | Whether to bypass actual execution of the DDL, and simply run the compare. |
Outputs
Output Name | Required | Description |
|---|---|---|
FDORA_OUT_BASELINE_ID | ||
| FDORA_OUT_NEW_BASELINE_ID | ||
| FDORA_OUT_DELTA_BASELINE_ID | ||
| FDORA_OUT_DROP_TABLE_COUNT | ||
| FDORA_OUT_CREATE_TABLE_COUNT | ||
| FDORA_OUT_ALTER_TABLE_COUNT | ||
| FDORA_OUT_DROP_COLUMNS_COUNT | ||
| FDORA_OUT_ADD_COLUMNS_COUNT | ||
| FDORA_OUT_MODIFY_COLUMN_COUNT | ||
| FDORA_OUT_DROP_CONSTRAINT_COUNT | ||
| FDORA_OUT_ADD_CONSTRAINT_COUNT | ||
| FDORA_OUT_MODIFY_CONSTRAINT_COUNT | ||
| FDORA_OUT_DROP_INDEX_COUNT | ||
| FDORA_OUT_CREATE_INDEX_COUNT | ||
| FDORA_OUT_ALTER_INDEX_COUNT | ||
| FDORA_OUT_DROP_VIEW_COUNT | ||
| FDORA_OUT_CREATE_VIEW_COUNT | ||
| FDORA_OUT_ALTER_VIEW_COUNT | ||
| FDORA_OUT_DROP_SEQUENCE_COUNT | ||
| FDORA_OUT_CREATE_SEQUENCE_COUNT | ||
| FDORA_OUT_ALTER_SEQUENCE_COUNT | ||
| FDORA_OUT_DROP_PROCEDURE_COUNT | ||
| FDORA_OUT_CREATE_PROCEDURE_COUNT | ||
| FDORA_OUT_ALTER_PROCEDURE_COUNT | ||
| FDORA_OUT_DROP_TRIGGER_COUNT | ||
| FDORA_OUT_CREATE_TRIGGER_COUNT | ||
| FDORA_OUT_ALTER_TRIGGER_COUNT | ||
| FDORA_OUT_DROP_SYNONYM_COUNT | ||
| FDORA_OUT_CREATE_SYNONYM_COUNT | ||
| FDORA_OUT_DROP_FUNCTION_COUNT | ||
| FDORA_OUT_CREATE_FUNCTION_COUNT | ||
| FDORA_OUT_ALTER_FUNCTION_COUNT | ||
| FDORA_OUT_DROP_TYPE_COUNT | ||
| FDORA_OUT_CREATE_TYPE_COUNT | ||
| FDORA_OUT_ALTER_TYPE_COUNT | ||
| FDORA_OUT_DROP_TYPE_BODY_COUNT | ||
| FDORA_OUT_CREATE_TYPE_BODY_COUNT | ||
| FDORA_OUT_ALTER_TYPE_BODY_COUNT | ||
| FDORA_OUT_DROP_PACKAGE_COUNT | ||
| FDORA_OUT_CREATE_PACKAGE_COUNT | ||
| FDORA_OUT_ALTER_PACKAGE_COUNT | ||
| FDORA_OUT_DROP_PACKAGE_BODY_COUNT | ||
| FDORA_OUT_CREATE_PACKAGE_BODY_COUNT | ||
| FDORA_OUT_ALTER_PACKAGE_BODY_COUNT | ||
| FDORA_OUT_DROP_MVIEW_COUNT | ||
| FDORA_OUT_CREATE_MVIEW_COUNT | ||
| FDORA_OUT_ALTER_MVIEW_COUNT | ||
| FDORA_OUT_DROP_MVIEW_LOG_COUNT | ||
| FDORA_OUT_CREATE_MVIEW_LOG_COUNT | ||
| FDORA_OUT_ALTER_MVIEW_LOG_COUNT | ||
| FDORA_OUT_OBJECT_GRANT_COUNT | ||
| FDORA_OUT_BL_TABLE_COUNT | ||
| FDORA_OUT_BL_INDEX_COUNT | ||
| FDORA_OUT_BL_CONSTRAINT_COUNT | ||
| FDORA_OUT_BL_SEQUENCE_COUNT | ||
| FDORA_OUT_BL_PROCEDURES_COUNT | ||
| FDORA_OUT_BL_VIEWS_COUNT | ||
| FDORA_OUT_BL_SYNONYMS_COUNT | ||
| FDORA_OUT_BL_MVIEW_COUNT | ||
| FDORA_OUT_BL_MVIEW_LOG_COUNT | ||
| FDORA_OUT_RENAME_TABLE_COUNT | ||
| FDORA_OUT_RENAME_COLUMN_COUNT | ||
| FDORA_OUT_RENAME_CONSTRAINT_COUNT | ||
| FDORA_OUT_RENAME_INDEX_COUNT | ||
| FDORA_OUT_RENAME_VIEW_COUNT | ||
| FDORA_OUT_RENAME_SEQUENCE_COUNT | ||
| FDORA_OUT_RENAME_TRIGGER_COUNT | ||
| FDORA_OUT_RENAME_SYNONYM_COUNT | ||
| FDORA_OUT_BL_PRIVILEGES_COUNT |
Artifacts
This operation consumes artifacts from the artifacts repository.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
Endpoint Execution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
Special Considerations
[Delete section if not needed]
Describe any dependencies between properties that may exist or anything that that isn’t really covered above but is relevant to this operation.