Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 FDORAproperty FDORA_SCHEMA_NAME blank. In this case, the schema will be set to the value of FDORAof 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

Then it is not required.

Property Name

Property Code

Required

Description

Oracle Database Schema Name(s)

FDORA_SCHEMA_NAME

Yes, until version 5.5.1.

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

environment instance

Target parameter as the schema name

.Typically this will be provided. However, since release 5.5.1, this property is optional

.


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

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.

...

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.

...