recreateBuildDB
- Karl Henselin
- Joel Wenzel
Recreates the build database from a file. This operation will destructively revert the build database to the contents of the files found in the FD_TEMP_DIR.
The DDL statements must be delimited by a forward slash (/) on its own line.
DDL index and constraint creation statements must reside outside of the table creation statement as seen below:
CREATE TABLE DBTEST2.PROJECT_OBJECT_ATTRIBUTE_VAL
(
PROJECT_OBJECT_ATTR_VAL_ID NUMBER(20, 0) NOT NULL
, PROJECT_OBJECT_ATTR_ID NUMBER(20, 0) NOT NULL
, SEQUENCE_NUMBER NUMBER(8, 0) NOT NULL
, PROJECT_OBJECT_ATTR_VAL VARCHAR2(4000) NOT NULL
, CREATED_ON TIMESTAMP NOT NULL
, CREATED_BY VARCHAR2(128) NOT NULL
, UPDATED_ON TIMESTAMP NOT NULL
, UPDATED_BY VARCHAR2(128) NOT NULL
, VERSION_NUMBER NUMBER(8, 0)
, CONSTRAINT PROJECT_OBJECT_ATTR_VAL_PK PRIMARY KEY
(
PROJECT_OBJECT_ATTR_VAL_ID
)
ENABLE
);
/
CREATE UNIQUE INDEX DBTEST2.PROJECT_OBJECT_ATTR_PK ON DBTEST2.PROJECT_OBJECT_ATTRIBUTE (PROJECT_OBJECT_ATTR_ID ASC);
This will cause data loss in the build environment database.
Environment/Instance 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. |
| 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. |
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. |
Inputs
| Input Name | Input Code | Required | Description |
|---|---|---|---|
Outputs
Output Name | Required | Description |
|---|---|---|
Artifacts
This operation doesn’t consume or produce any artifacts.
Endpoint Selection
This operation will select all available endpoints associated to the environment/instance.
Endpoint Execution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
- style