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 (Keep one and edit if desired.)
This operation doesn’t consume or produce any artifacts.
This operation consumes artifacts from the artifacts repository.
This operation produces artifacts that will be stored in the artifacts repository.
This operation delegates the consume/produce artifacts decision to the workflow developer.
Endpoint Selection (Keep one and edit if desired.)
This operation will select all available endpoints associated to the environment instance which have resource type of {Resource Type}.
This operation will select all available endpoints associated to the environment/instance.
This operation delegates the selection to the workflow developer to determine.
Endpoint Execution (Keep one and edit if desired.)
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
This operation will execute on all of the selected endpoints and will execute on each of the selected endpoints.
This operation will select all available endpoints associated to the environment instance which have resource type of {resource type}.
This operations delegates the execution to the workflow developer to decide.
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.