...
Property Name | Property Code | Required | Description |
|---|---|---|---|
Oracle Database URL | FDORA_URL | Yes | The JDBC URL for the target Oracle database. |
| Oracle Database User | FDORA_USER | Yes | The username that will be used to connect to the target Oracle Database. |
| 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. |
| 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 | Comma-separated list of schemas controlled by this project. |
| 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. |
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. |
| 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 NEW_OWNER.NEW_TABLE_NAME=OLD_OWNER.OLD_TABLE_NAME NOTE*** Multiple table renames can be listed by comma separating them on the input. |
| Index Renames | FDORA_INDEX_RENAMES | No | Index rename string. The format is NEW_OWNER.NEW_INDEX_NAME=OLD_OWNER.OLD_INDEX_NAME NOTE*** Multiple index renames can be listed by comma separating them on the input. |
| Column Renames | FDORA_COLUMN_RENAMES | No | Column rename string. The format is NEW_OWNER.NEW_TABLE_NAME.NEW_COLUMN_NAME=OLD_OWNER.OLD_TABLE_NAME.OLD_COLUMN_NAME NOTE*** Multiple column renames can be listed by comma separating them on the input. |
| Trigger Renames | FDORA_TRIGGER_RENAMES | No | Trigger rename string. The format is NEW_OWNER.NEW_TRIGGER_NAME=OLD_OWNER.OLD_TRIGGER_NAME NOTE*** Multiple trigger renames can be listed by comma separating them on the input. |
| Constraint Renames | FDORA_CONSTRAINT_RENAMES | No | Constraint rename string. The format is NEW_OWNER.NEW_TABLE_NAME.NEW_CONSTRAINT_NAME=OLD_OWNER.OLD_TABLE_NAME.OLD_CONSTRAINT_NAME NOTE*** Multiple constraint renames can be listed by comma separating them on the input. |
| Synonym Renames | FDORA_SYNONYM_RENAMES | No | Synonym rename string. The format is NEW_OWNER.NEW_SYNONYM_NAME=OLD_OWNER.OLD_SYNONYM_NAME NOTE*** Multiple synonym renames can be listed by comma separating them on the input. |
| Sequence Renames | FDORA_SEQUENCE_RENAMES | No | Sequence rename string. The format is NEW_OWNER.NEW_SEQUENCE_NAME=OLD_OWNER.OLD_SEQUENCE_NAME NOTE*** Multiple sequence renames can be listed by comma separating them on the input. |
| View Renames | FDORA_VIEW_RENAMES | No | View rename string. The format is NEW_OWNER.NEW_VIEW_NAME=OLD_OWNER.OLD_VIEW_NAME NOTE*** Multiple view renames can be listed by comma separating them on the input. |
...