recreateBuildDB
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.
Target Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
Oracle Database URL |
| Yes | The JDBC URL for the target Oracle database. This should be a complete JDBC URL (e.g. |
Oracle Database 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 |
| Yes | The password for Oracle Database User. |
Target JDBC Driver Path. |
| Yes | Path containing JDBC driver for target database connection. |
Project Properties
Property Name | Property Code | Required | Description |
---|---|---|---|
Oracle Database Schema Name(s) |
| Yes | Comma-separated list of schemas controlled by this project. Leave this parameter blank if you want to have schema name different across environments. |
Artifacts
This operation doesn’t consume or produce any artifacts.
Endpoint Selection
This operation will select all available endpoints associated to the Target.
Endpoint Execution
This operation will execute on any one of the selected endpoints and will be random in the determination of which one.
- style