Hi,

We need DBA support to run the following sql which will create a new table in our Production db.

We don't foresee any issues with running this sql as it has been tested in our test environment. However, if an issue were to arise we may need your help diagnosing the fix. Furthermore, we are not currently sure that we can run this sql.

The sql needs to be run at a specific time during our release on Tuesday 19th November 8.30am. Will you be able to run the sql for us at that time and provide support afterwards if needed?


INSERT INTO PRD_CMM.DB_SCHEMA_VERSION (VERSION_MAJOR, VERSION_MINOR, VERSION_POINT, SCRIPT_NUMBER) values (2,80,0,1);




CREATE TABLE PRD_CMM.CMM_CONTENT_ASSET_MARKERS_MKR
( ID NUMBER(10,0) NOT NULL ENABLE,
VAS_ID NUMBER(10,0) NOT NULL ENABLE,
START_FRAME VARCHAR2(256),
END_FRAME VARCHAR2(256),
FIELD_ID VARCHAR2(256) NOT NULL ENABLE,
CONSTRAINT PK_CMM_CAM_MKR PRIMARY KEY (ID),
CONSTRAINT fK_CMM_CAM_MKR_VAS_ID FOREIGN KEY (VAS_ID) REFERENCES CMM_CONTENT_ASSET_CAS(VAS_ID));

CREATE SEQUENCE PRD_CMM.SEQ_CMM_CAM_MKR
START WITH 1000
MAXVALUE 999999999999999999999999999
MINVALUE 1000
NOCYCLE
CACHE 20
NOORDER;