...
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. |
Oracle Database User | FDORA_USER | Yes | The username that will be used to connect to the target Oracle Database. NOTE*** If the project property
|
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. |
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. |
...
Property Name | Property Code | Required | Description |
---|---|---|---|
Oracle Database Schema Name(s) | FDORA_SCHEMA_NAME | Yes | 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 parameter as the schema name for the baseline. |
Oracle Object Types | FDORA_OBJECT_TYPES | Yes | The Oracle object types which are being managed in partial deployment projects. By default all object types are selected. This could be used in combination with security options so that certain user groups are unable to build and deploy tables or other objects. |
...
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
| ||
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 |
---|---|---|
| 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. |
...
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.