Oracle Cloud Connector Database

Shared Templates allows you to use the Cloud Connector database as your file storage Drive.

Requirements and Setup

When you select the Oracle Cloud Connector Database as the preferred Shared Templates Drive type, a database table must be created to store the Shared Templates files.

To create the Shared Templates Drive database table, add the following script to your Oracle Cloud Connector replication tasks:

CREATE TABLE XXIS_SHARED_TEMPLATES_TBL

(

ID VARCHAR (30) NOT NULL

, FILE_NAME VARCHAR(256)

, FILE_CONTENT_TYPE VARCHAR(256) NOT NULL

, FILE_DATA LONGBLOB

, UPLOAD_DATE DATETIME

, LANGUAGE VARCHAR(4) DEFAULT null

, MYSQL_CHARSET VARCHAR(30) DEFAULT null,

CONSTRAINT XXIS_SHARED_TEMPLATES_TBL_PK PRIMARY KEY (ID)

);