Synchronizes Oracle DDL to upgrade a schema to the supplied baseline.
Environment/Instance Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle Database URL | FDORA_URL | Yes | The JDBC URL for the target Oracle database. |
| Oracle Database User | FDORA_USER | Yes | TheFDORA_DRIVER_PATH username that will be used to connect to the target Oracle Database. |
| Oracle Database Password | FDORA_PASSWORD | Yes | The password for Oracle Database User. |
| Target JDBC Driver Path. | FDORA_DRIVER_PATH | Yes | Path containing JDBC driver for target database connection. |
| DDL Repo JDBC Driver Path | FDORA_DDL_DRIVER_PATH | Yes | Path containing JDBC driver for DDL repository database connection. |
| DDL Repository URL | FDORA_DDL_URL | Yes | The JDBC URL for the DDL repository. |
| DDL Repository User | FDORA_DDL_USER | Yes | The userid used to connect to the DDL repository. |
| DDL Repository Password | FDORA_DDL_PASSWORD | Yes | The password for the DDL repository userid. |
Project Properties
Property Name | Property Code | Required | Description |
|---|---|---|---|
| Oracle Object Types | FDORA_OBJECT_TYPES | Yes | The Oracle object types which are being managed. Select multiple from FUNCTION,INDEX,PACKAGE,PACKAGE BODY,PROCEDURE,SEQUENCE,SYNONYMN,TABLE,TRIGGER,TYPE,TYPE BODY,VIEW |
| Oracle Database Schema Name(s) | FDORA_SCHEMA_NAME | Yes | Comma-separated list of schemas controlled by this project. |
Inputs
| 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 |
| 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 | No | |
| FDORA_OUT_NEW_BASELINE_ID | No | |
| FDORA_OUT_DELTA_BASELINE_ID | No | |
| FDORA_OUT_DROP_TABLE_COUNT | No | |
| FDORA_OUT_CREATE_TABLE_COUNT | No | |
| FDORA_OUT_ALTER_TABLE_COUNT | No | |
| FDORA_OUT_DROP_COLUMNS_COUNT | No | |
| FDORA_OUT_ADD_COLUMNS_COUNT | No | |
| FDORA_OUT_MODIFY_COLUMN_COUNT | No | |
| FDORA_OUT_DROP_CONSTRAINT_COUNT | No | |
| FDORA_OUT_ADD_CONSTRAINT_COUNT | No | |
| FDORA_OUT_MODIFY_CONSTRAINT_COUNT | No | |
| FDORA_OUT_DROP_INDEX_COUNT | No | |
| FDORA_OUT_CREATE_INDEX_COUNT | No | |
| FDORA_OUT_ALTER_INDEX_COUNT | No | |
| FDORA_OUT_DROP_VIEW_COUNT | No | |
| FDORA_OUT_CREATE_VIEW_COUNT | No | |
| FDORA_OUT_ALTER_VIEW_COUNT | No | |
| FDORA_OUT_DROP_SEQUENCE_COUNT | No | |
| FDORA_OUT_CREATE_SEQUENCE_COUNT | No | |
| FDORA_OUT_ALTER_SEQUENCE_COUNT | No | |
| FDORA_OUT_DROP_PROCEDURE_COUNT | No | |
| FDORA_OUT_CREATE_PROCEDURE_COUNT | No | |
| FDORA_OUT_ALTER_PROCEDURE_COUNT | No | |
| FDORA_OUT_DROP_TRIGGER_COUNT | No | |
| FDORA_OUT_CREATE_TRIGGER_COUNT | No | |
| FDORA_OUT_ALTER_TRIGGER_COUNT | No | |
| FDORA_OUT_DROP_SYNONYM_COUNT | No | |
| FDORA_OUT_CREATE_SYNONYM_COUNT | No | |
| FDORA_OUT_DROP_FUNCTION_COUNT | No | |
| FDORA_OUT_CREATE_FUNCTION_COUNT | No | |
| FDORA_OUT_ALTER_FUNCTION_COUNT | No | |
| FDORA_OUT_DROP_TYPE_COUNT | No | |
| FDORA_OUT_CREATE_TYPE_COUNT | No | |
| FDORA_OUT_ALTER_TYPE_COUNT | No | |
| FDORA_OUT_DROP_TYPE_BODY_COUNT | No | |
| FDORA_OUT_CREATE_TYPE_BODY_COUNT | No | |
| FDORA_OUT_ALTER_TYPE_BODY_COUNT | No | |
| FDORA_OUT_DROP_PACKAGE_COUNT | No | |
| FDORA_OUT_CREATE_PACKAGE_COUNT | No | |
| FDORA_OUT_ALTER_PACKAGE_COUNT | No | |
| FDORA_OUT_DROP_PACKAGE_BODY_COUNT | No | |
| FDORA_OUT_CREATE_PACKAGE_BODY_COUNT | No | |
| FDORA_OUT_ALTER_PACKAGE_BODY_COUNT | No | |
| FDORA_OUT_DROP_MVIEW_COUNT | No | |
| FDORA_OUT_CREATE_MVIEW_COUNT | No | |
| FDORA_OUT_ALTER_MVIEW_COUNT | No | |
| FDORA_OUT_DROP_MVIEW_LOG_COUNT | No | |
| FDORA_OUT_CREATE_MVIEW_LOG_COUNT | No | |
| FDORA_OUT_ALTER_MVIEW_LOG_COUNT | No | |
| FDORA_OUT_OBJECT_GRANT_COUNT | No | |
| FDORA_OUT_BL_TABLE_COUNT | No | |
| FDORA_OUT_BL_INDEX_COUNT | No | |
| FDORA_OUT_BL_CONSTRAINT_COUNT | No | |
| FDORA_OUT_BL_SEQUENCE_COUNT | No | |
| FDORA_OUT_BL_PROCEDURES_COUNT | No | |
| FDORA_OUT_BL_VIEWS_COUNT | No | |
| FDORA_OUT_BL_SYNONYMS_COUNT | No | |
| FDORA_OUT_BL_MVIEW_COUNT | No | |
| FDORA_OUT_BL_MVIEW_LOG_COUNT | No | |
| FDORA_OUT_RENAME_TABLE_COUNT | No | |
| FDORA_OUT_RENAME_COLUMN_COUNT | No | |
| FDORA_OUT_RENAME_CONSTRAINT_COUNT | No | |
| FDORA_OUT_RENAME_INDEX_COUNT | No | |
| FDORA_OUT_RENAME_VIEW_COUNT | No | |
| FDORA_OUT_RENAME_SEQUENCE_COUNT | No | |
| FDORA_OUT_RENAME_TRIGGER_COUNT | No | |
| FDORA_OUT_RENAME_SYNONYM_COUNT | No | |
| FDORA_OUT_BL_PRIVILEGES_COUNT | No |
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.