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 8 Next »

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 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 Object TypesFDORA_OBJECT_TYPESYes

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

Preview ExecutionFDORA_PREVIEW_EXECUTIONNo

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

Defaults to false.

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