...

Info
The DDL statements must be delimited by a forward slash (/) on its own line.

Info

DDL index and constraint creation statement statements must reside outside of the table creation statement as seen below:

CREATE TABLE DBTEST2.

For example:

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);

Warning
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.

Input Name	Input Code	Required	Description

Output Name	Required	Description

This operation doesn’t consume or produce any artifacts.

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.

...