Upgrades 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). The schema names must be the same in the different environments.

Info
When deploying a baseline that contains rename views, sequences, or synonyms, the value of Environment Instance Target Property `FDORA_USER` must be the owner of the objects. Running the operation as another user will fail with `ORA-04043`.

Info

When renaming columns and tables in the same build, set the properties like:

FDORA_TABLE_RENAMES - schema.old_table = schema.new_table

FDORA_COLUMN_RENAMES - schema.old_table.old_column = schema.new_table.new_column

As of release 5.5.0.1, you can specify renames without Schema prefixes, provided that you also leave the project property FDORA_SCHEMA_NAME blank. In this case, the schema will be set to the value of FDORA_USER and this value will be used for all renames.

FDORA_TABLE_RENAMES -

...

old_table = new_table

FDORA_COLUMN_RENAMES - old_table.old_column = new_table.new_column

Target Properties

Property Name	Property Code	Required	Description
Oracle Database URL	`FDORA_URL`	Yes	The JDBC URL for the target Oracle database. This should be a complete JDBC URL (e.g. `jdbc:oracle:thin:@localhost:1521:xe`)
Oracle Database User	`FDORA_USER`	Yes	The username that will be used to connect to the target Oracle Database. NOTE*** If the project property FDORA_SCHEMA_NAME is not set, then this becomes the schema.
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. This should be a complete JDBC URL (e.g. jdbc:oracle:thin:@localhost:1521:xe)
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

No	Comma-separated list of schemas controlled by this project

.

...

.

Leave this parameter blank if you want to have schema name different across environments.
The plugin will then use the FDORA_USER Target parameter as the schema name.

If it isn't provided, FDORA_USER will be the schema that is tracked and may differ through environments.

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

Preview Execution

FDORA_PREVIEW_EXECUTION

No

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

Defaults to true.

For Pre-deploy workflow this should be checked to only run compare and generate report for review. In addition FDORA_OUT_CHANGES_EXIST output should be saved in FD_REVIEW_REQUIRED workflow output for Pre-deploy workflow and in addition FD_REVIEW_GROUP to assign Review tasks to specific group(s).

Automatically rollback changes if the deployment fails

FDORA_ROLLBACK_ON_FAIL

No

Added in 4.0.3.65.

If a deployment failure occurs, should the database be rolled back to the previous state?

Defaults to false.

If true, the snapshot taken as the deployment starts will be rolled back to. If false, the database will be left in the state it is in after the first failure. The deployment stops after the first failure occurs.

Fail the workflow if it is rolled back successfully

FDORA_FAIL_AFTER_ROLLBACK

No

Added in 4.0.3.65.

If a deployment failure occurs, but it is successfully rolled back to the previous version, should the workflow still be failed?

Defaults to true.

...


Include Tablespaces	`FDORA_TABLESPACE_FLG`	No	Setting this to true causes create statements to include tablespace information where appropriate. This adds the tablespace clause to all creates. Defaults to false. Requires segments attributes to be enabled also.
Include Segment attributes	`FDORA_SEGMENT_ATTRIBUTES_FLG`	No	Setting this to true causes create statements to include tablespace segment attribute information where appropriate. Defaults to false.
Include Storage	`FDORA_STORAGE_FLG`	No	Setting this to true causes create statements to include storage information where appropriate. This adds the STOREAGE clause with its values on all creates. Defaults to false. Requires segments attributes to be enabled also.

Outputs

Output Name	Required	Description
`FDORA_OUT_BASELINE_ID`	No	This is the baseline ID currently deployed to the target environment OR the baseline ID created from this deployment.
`FDORA_OUT_NEW_BASELINE_ID`	No	This is the baseline ID being deployed to this environment.
`FDORA_OUT_DELTA_BASELINE_ID`	No	The ID to track the DDL used for this deployment.
`FDORA_OUT_DROP_TABLE_COUNT`	No	Count of tables dropped.
`FDORA_OUT_CREATE_TABLE_COUNT`	No	Count of tables created.
`FDORA_OUT_ALTER_TABLE_COUNT`	No	Count of tables altered.
`FDORA_OUT_DROP_COLUMNS_COUNT`	No	Count of columns dropped.
`FDORA_OUT_ADD_COLUMNS_COUNT`	No	Count of columns added.
`FDORA_OUT_MODIFY_COLUMN_COUNT`	No	Count of columns modified.
`FDORA_OUT_DROP_CONSTRAINT_COUNT`	No	Count of constraints dropped.
`FDORA_OUT_ADD_CONSTRAINT_COUNT`	No	Count of constraints added.
`FDORA_OUT_MODIFY_CONSTRAINT_COUNT`	No	Count of constraints modified.
`FDORA_OUT_DROP_INDEX_COUNT`	No	Count of indexes dropped.
`FDORA_OUT_CREATE_INDEX_COUNT`	No	Count of indexes created.
`FDORA_OUT_ALTER_INDEX_COUNT`	No	Count of indexes altered.
`FDORA_OUT_DROP_VIEW_COUNT`	No	Count of views dropped.
`FDORA_OUT_CREATE_VIEW_COUNT`	No	Count of views created.
`FDORA_OUT_ALTER_VIEW_COUNT`	No	Count of views altered.
`FDORA_OUT_DROP_SEQUENCE_COUNT`	No	Count of sequences dropped.
`FDORA_OUT_CREATE_SEQUENCE_COUNT`	No	Count of sequences created.
`FDORA_OUT_ALTER_SEQUENCE_COUNT`	No	Count of sequences altered.
`FDORA_OUT_DROP_PROCEDURE_COUNT`	No	Count of procedures dropped.
`FDORA_OUT_CREATE_PROCEDURE_COUNT`	No	Count of procedures created.
`FDORA_OUT_ALTER_PROCEDURE_COUNT`	No	Count of procedures altered.
`FDORA_OUT_DROP_TRIGGER_COUNT`	No	Count of triggers dropped.
`FDORA_OUT_CREATE_TRIGGER_COUNT`	No	Count of triggers created.
`FDORA_OUT_ALTER_TRIGGER_COUNT`	No	Count of triggered altered.
`FDORA_OUT_DROP_SYNONYM_COUNT`	No	Count of synonyms dropped.
`FDORA_OUT_CREATE_SYNONYM_COUNT`	No	Count of synonyms created.
`FDORA_OUT_DROP_FUNCTION_COUNT`	No	Count of functions dropped.
`FDORA_OUT_CREATE_FUNCTION_COUNT`	No	Count of functions created.
`FDORA_OUT_ALTER_FUNCTION_COUNT`	No	Count of functions altered.
`FDORA_OUT_DROP_TYPE_COUNT`	No	Count of types dropped.
`FDORA_OUT_CREATE_TYPE_COUNT`	No	Count of types created.
`FDORA_OUT_ALTER_TYPE_COUNT`	No	Count of types altered.
`FDORA_OUT_DROP_TYPE_BODY_COUNT`	No	Count of type body drops.
`FDORA_OUT_CREATE_TYPE_BODY_COUNT`	No	Count of type body creates.
`FDORA_OUT_ALTER_TYPE_BODY_COUNT`	No	Count of type body alters.
`FDORA_OUT_DROP_PACKAGE_COUNT`	No	Count of packages dropped.
`FDORA_OUT_CREATE_PACKAGE_COUNT`	No	Count of packages created.
`FDORA_OUT_ALTER_PACKAGE_COUNT`	No	Count of packages altered.
`FDORA_OUT_DROP_PACKAGE_BODY_COUNT`	No	Count of package body drops.
`FDORA_OUT_CREATE_PACKAGE_BODY_COUNT`	No	Count of package body creates.
`FDORA_OUT_ALTER_PACKAGE_BODY_COUNT`	No	Count of package body alters.
`FDORA_OUT_DROP_MVIEW_COUNT`	No	Count of materialized view drops.
`FDORA_OUT_CREATE_MVIEW_COUNT`	No	Count of materialized view creates.
`FDORA_OUT_ALTER_MVIEW_COUNT`	No	Count of materialized view alters.
`FDORA_OUT_DROP_MVIEW_LOG_COUNT`	No	Count of materialized view log drops.
`FDORA_OUT_CREATE_MVIEW_LOG_COUNT`	No	Count of materialized view log creates.
`FDORA_OUT_ALTER_MVIEW_LOG_COUNT`	No	Count of materialized view log alters.
`FDORA_OUT_OBJECT_GRANT_COUNT`	No	Count of object grants.
`FDORA_OUT_BL_TABLE_COUNT`	No	Count of tables in the new baseline.
`FDORA_OUT_BL_INDEX_COUNT`	No	Count of indexes in the new baseline.
`FDORA_OUT_BL_CONSTRAINT_COUNT`	No	Count of constraints in the new baseline.
`FDORA_OUT_BL_SEQUENCE_COUNT`	No	Count of sequences in the new baseline.
`FDORA_OUT_BL_PROCEDURES_COUNT`	No	Count of procedures in the new baseline.
`FDORA_OUT_BL_VIEWS_COUNT`	No	Count of views in the new baseline.
`FDORA_OUT_BL_SYNONYMS_COUNT`	No	Count of synonyms in the new baseline.
`FDORA_OUT_BL_MVIEW_COUNT`	No	Count of materialized views in the new baseline.
`FDORA_OUT_BL_MVIEW_LOG_COUNT`	No	Count of materialized view logs in the new baseline.
`FDORA_OUT_RENAME_TABLE_COUNT`	No	Count of table renames processed.
`FDORA_OUT_RENAME_COLUMN_COUNT`	No	Count of column renames processed.
`FDORA_OUT_RENAME_CONSTRAINT_COUNT`	No	Count of constraint renames processed.
`FDORA_OUT_RENAME_INDEX_COUNT`	No	Count of index renames processed.
`FDORA_OUT_RENAME_VIEW_COUNT`	No	Count of view renames processed.
`FDORA_OUT_RENAME_SEQUENCE_COUNT`	No	Count of sequence renames processed.
`FDORA_OUT_RENAME_TRIGGER_COUNT`	No	Count of trigger renames processed.
`FDORA_OUT_RENAME_SYNONYM_COUNT`	No	Count of synonym renames processed.
`FDORA_OUT_BL_PRIVILEGES_COUNT`	No	Count of object privileges in the new baseline.

...


`FDORA_OUT_CHANGES_EXIST`	No	Returns true if changes exist as part of execution of this operation. This output can be saved in FD_REVIEW_REQUIRED output for Pre-deploy workflow and in addition FD_REVIEW_GROUP to assign Review tasks to specific group(s).

Artifacts

This operation consumes artifacts from the artifacts repository.

Endpoint Selection

This operation will select all available endpoints associated to the environment/instanceTarget.

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

The plugin currently requires the source and target schema names to be the same.

Versions Compared

Old Version 29

New Version Current

Key

Target Properties

Project Properties

Inputs

Outputs

Artifacts

Endpoint Selection

Endpoint Execution

Special Considerations

Page Comparison

Versions Compared

Old Version 29

New Version Current

Key

Target Properties

Project Properties

Inputs

Outputs

Artifacts

Endpoint Selection

Endpoint Execution

Special Considerations