Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »

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 UserFDORA_USERYesThe username that will be used to connect to the target Oracle Database.
Oracle Database PasswordFDORA_PASSWORDYesThe password for Oracle Database User.
Target JDBC Driver Path.FDORA_DRIVER_PATHYesPath containing JDBC driver for target database connection.
DDL Repo JDBC Driver PathFDORA_DDL_DRIVER_PATHYesPath containing JDBC driver for DDL repository database connection.
DDL Repository URLFDORA_DDL_URLYesThe JDBC URL for the DDL repository.
DDL Repository UserFDORA_DDL_USERYesThe userid used to connect to the DDL repository.
DDL Repository PasswordFDORA_DDL_PASSWORDYesThe 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 ActionFDORA_COL_DROP_ACTIONNo

Determines what action to take for "dropping" columns.

Can be set to SET UNUSED or DROP.

Defaults to SET UNUSED

Create BaselineFDORA_CREATE_BASELINE_FLGNo

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

Defaults to false, which indicates that the DDL on the target server should be assumed to have been unaltered since the last deploy.

Currently the deployments are considered to be successful, even if they were previews or failed.

It is recommended that this be set to true.

Preview ExecutionFDORA_PREVIEW_EXECUTIONNo

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_IDNo
FDORA_OUT_DELTA_BASELINE_IDNo
FDORA_OUT_DROP_TABLE_COUNTNo
FDORA_OUT_CREATE_TABLE_COUNTNo
FDORA_OUT_ALTER_TABLE_COUNTNo
FDORA_OUT_DROP_COLUMNS_COUNTNo
FDORA_OUT_ADD_COLUMNS_COUNTNo
FDORA_OUT_MODIFY_COLUMN_COUNTNo
FDORA_OUT_DROP_CONSTRAINT_COUNTNo
FDORA_OUT_ADD_CONSTRAINT_COUNTNo
FDORA_OUT_MODIFY_CONSTRAINT_COUNTNo
FDORA_OUT_DROP_INDEX_COUNTNo
FDORA_OUT_CREATE_INDEX_COUNTNo
FDORA_OUT_ALTER_INDEX_COUNTNo
FDORA_OUT_DROP_VIEW_COUNTNo
FDORA_OUT_CREATE_VIEW_COUNTNo
FDORA_OUT_ALTER_VIEW_COUNTNo
FDORA_OUT_DROP_SEQUENCE_COUNTNo
FDORA_OUT_CREATE_SEQUENCE_COUNTNo
FDORA_OUT_ALTER_SEQUENCE_COUNTNo
FDORA_OUT_DROP_PROCEDURE_COUNTNo
FDORA_OUT_CREATE_PROCEDURE_COUNTNo
FDORA_OUT_ALTER_PROCEDURE_COUNTNo
FDORA_OUT_DROP_TRIGGER_COUNTNo
FDORA_OUT_CREATE_TRIGGER_COUNTNo
FDORA_OUT_ALTER_TRIGGER_COUNTNo
FDORA_OUT_DROP_SYNONYM_COUNTNo
FDORA_OUT_CREATE_SYNONYM_COUNTNo
FDORA_OUT_DROP_FUNCTION_COUNTNo
FDORA_OUT_CREATE_FUNCTION_COUNTNo
FDORA_OUT_ALTER_FUNCTION_COUNTNo
FDORA_OUT_DROP_TYPE_COUNTNo
FDORA_OUT_CREATE_TYPE_COUNTNo
FDORA_OUT_ALTER_TYPE_COUNTNo
FDORA_OUT_DROP_TYPE_BODY_COUNTNo
FDORA_OUT_CREATE_TYPE_BODY_COUNTNo
FDORA_OUT_ALTER_TYPE_BODY_COUNTNo
FDORA_OUT_DROP_PACKAGE_COUNTNo
FDORA_OUT_CREATE_PACKAGE_COUNTNo
FDORA_OUT_ALTER_PACKAGE_COUNTNo
FDORA_OUT_DROP_PACKAGE_BODY_COUNTNo
FDORA_OUT_CREATE_PACKAGE_BODY_COUNTNo
FDORA_OUT_ALTER_PACKAGE_BODY_COUNTNo
FDORA_OUT_DROP_MVIEW_COUNTNo
FDORA_OUT_CREATE_MVIEW_COUNTNo
FDORA_OUT_ALTER_MVIEW_COUNTNo
FDORA_OUT_DROP_MVIEW_LOG_COUNTNo
FDORA_OUT_CREATE_MVIEW_LOG_COUNTNo
FDORA_OUT_ALTER_MVIEW_LOG_COUNTNo
FDORA_OUT_OBJECT_GRANT_COUNTNo
FDORA_OUT_BL_TABLE_COUNTNo
FDORA_OUT_BL_INDEX_COUNTNo
FDORA_OUT_BL_CONSTRAINT_COUNTNo
FDORA_OUT_BL_SEQUENCE_COUNTNo
FDORA_OUT_BL_PROCEDURES_COUNTNo
FDORA_OUT_BL_VIEWS_COUNTNo
FDORA_OUT_BL_SYNONYMS_COUNTNo
FDORA_OUT_BL_MVIEW_COUNTNo
FDORA_OUT_BL_MVIEW_LOG_COUNTNo
FDORA_OUT_RENAME_TABLE_COUNTNo
FDORA_OUT_RENAME_COLUMN_COUNTNo
FDORA_OUT_RENAME_CONSTRAINT_COUNTNo
FDORA_OUT_RENAME_INDEX_COUNTNo
FDORA_OUT_RENAME_VIEW_COUNTNo
FDORA_OUT_RENAME_SEQUENCE_COUNTNo
FDORA_OUT_RENAME_TRIGGER_COUNTNo
FDORA_OUT_RENAME_SYNONYM_COUNTNo
FDORA_OUT_BL_PRIVILEGES_COUNTNo

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.


  • No labels