Upgrade the Oracle DDL of a specified schema to the supplied baseline. The baseline id is supplied by an artifact created by the createBaseline operation. The DDL is pulled from the DDL Repository and applied to the database specified by Oracle Database URL and Oracle Database Schema Name(s).

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	The 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 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

No

Whether to generate a baseline on the target environment and compare to new baseline.

Defaults to false

Preview Execution

FDORA_PREVIEW_EXECUTION

No

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

Defaults to true.

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.

synchronize