...
| 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 Defaults to | ||
| Revert to Baseline ID | FDORA_REVERT_TO_BASELINE_ID | No | Numeric ID of the baseline to revert an environment to. Leave blank to create a new baseline. | ||
| Table Renames | FDORA_TABLE_RENAMES | No | Table rename string. The format is
| ||
| Index Renames | FDORA_INDEX_RENAMES | No | Index rename string. The format is
| ||
| Column Renames | FDORA_COLUMN_RENAMES | No | Column rename string. The format is
| ||
| Trigger Renames | FDORA_TRIGGER_RENAMES | No | Trigger rename string. The format is
| ||
| Constraint Renames | FDORA_CONSTRAINT_RENAMES | No | Constraint rename string. The format is
| ||
| Synonym Renames | FDORA_SYNONYM_RENAMES | No | Synonym rename string. The format is
| ||
| Sequence Renames | FDORA_SEQUENCE_RENAMES | No | Sequence rename string. The format is
| ||
| View Renames | FDORA_VIEW_RENAMES | No | View rename string. The format is
|
Outputs
Output Name | Required | Description |
|---|---|---|
| No | Outputs the BaseLine ID which was built. |
FDORA_OUT_BL_TABLE_COUNT | No | Count of tables stored in the baseline. |
FDORA_OUT_BL_INDEX_COUNT | No | Count of indexes stored in the baseline. |
FDORA_OUT_BL_CONSTRAINT_COUNT | No | Count of constraints stored in the baseline. |
FDORA_OUT_BL_SEQUENCE_COUNT | No | Count of sequences stored in the baseline. |
FDORA_OUT_BL_PROCEDURES_COUNT | No | Count of procedures stored in the baseline. |
FDORA_OUT_BL_VIEWS_COUNT | No | Count of views stored in the baseline. |
FDORA_OUT_BL_SYNONYMS_COUNT | No | Count of synonyms stored in the baseline. |
FDORA_OUT_BL_MVIEW_COUNT | No | Count of materialized views stored in the baseline. |
FDORA_OUT_BL_MVIEW_LOG_COUNT | No | Count of materialized view logs stored in the baseline. |
FDORA_OUT_BL_PRIVILEGES_COUNT | No | Count of privileges stored in the baseline. |
Artifacts
This operation produces artifacts that will be stored in the artifacts repository. This artifact is an empty file whose name is used to select a revision from the DDL Repository.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
...
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
Special Considerations
For renames, the old_owner must must be the same as the new_owner.
For user defined type objects, special consideration should be given to implementing the force option on the type. In a scenario where a type is dependent on another type, there are scenarios where creating the child type with the force will make the deployment to future environments easier.
Example:
In this case, the type XX_WS_INPUT_T is a child of the type XX_WS_INPUT_TBL. By creating it with the force in the build database, the plugin will automatically carry that option forward:
create or replace TYPE XX_WS_INPUT_T FORCE AS OBJECT (
TABLE_NAME VARCHAR2( 30 )
,COLUMN_NAME VARCHAR2( 30 )
,IN_VALUE VARCHAR2( 250 )
);
create or replace TYPE XX_WS_INPUT_TBL AS TABLE OF XX_WS_INPUT_T;
Future changes to the XX_WS_INPUT_T type (like adding a column) will then flow through the plugin without issue because it will be recreated using the force option. Without the force option, the plugin would fail with the error message:
ORA-02303: cannot drop or replace a type with type or table dependents
Please note, the use of the force option will cause the parent type and any dependent type will be invalid and will require a recompile. This can complete in FlexDeploy by using the compile_invalid plugin operation in the workflow.
For types that are used within physical CREATE TABLE definitions, the use of the FORCE option is NOT recommended. It should only be used in scenario where the type is used within PL/SQL code.