CREATE BIGFILE TABLESPACE CM_F1T191_P2011JAN DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011FEB DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011MAR DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011APR DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011MAY DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011JUN DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011JUL DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011AUG DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011SEP DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011OCT DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011NOV DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_P2011DEC DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

CREATE BIGFILE TABLESPACE CM_F1T191_PMAX DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

 

CREATE TABLE F1_SYNC_REQ_IN

(

F1_SYNC_REQ_IN_ID CHAR(14) NOT NULL ENABLE,

BUS_OBJ_CD CHAR(30) DEFAULT ' ' NOT NULL ENABLE,

CRE_DTTM DATE NOT NULL ENABLE,

BO_STATUS_CD CHAR(12) DEFAULT ' ' NOT NULL ENABLE,

STATUS_UPD_DTTM DATE,

MAINT_OBJ_CD CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE,

NT_XID_CD CHAR(30 BYTE) DEFAULT ' ' NOT NULL ENABLE,

EXT_PK_VALUE1 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

EXT_PK_VALUE2 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

EXT_PK_VALUE3 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

EXT_PK_VALUE4 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

EXT_PK_VALUE5 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

PK_VALUE1 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

BO_DATA_AREA CLOB,

PRE_TRN_INIT_BO_DATA_AREA CLOB,

PRE_TRN_FIN_BO_DATA_AREA CLOB,

POST_TRN_BO_DATA_AREA CLOB,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

EXT_REFERENCE_ID CHAR(36) DEFAULT ' ' NOT NULL ENABLE,

F1_INITIAL_LOAD_SYNC_FLG CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

F1_COMPOSITE_SYNC_FLG CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

ILM_DT DATE,

ILM_ARCH_SW CHAR(1)

)

ENABLE ROW MOVEMENT

LOB (BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE)

LOB (PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE)

LOB (PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE)

LOB (POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE)

PARTITION BY RANGE(ILM_DT)

SUBPARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

SUBPARTITION TEMPLATE

(

SUBPARTITION S01 VALUES LESS THAN ( '12499999999999' ),

SUBPARTITION S02 VALUES LESS THAN ( '24999999999999' ),

SUBPARTITION S03 VALUES LESS THAN ( '37499999999999' ),

SUBPARTITION S04 VALUES LESS THAN ( '49999999999999' ),

SUBPARTITION S05 VALUES LESS THAN ( '62499999999999' ),

SUBPARTITION S06 VALUES LESS THAN ( '74999999999999' ),

SUBPARTITION S07 VALUES LESS THAN ( '87499999999999' ),

SUBPARTITION SMAX VALUES LESS THAN ( MAXVALUE )

)

(

PARTITION "P2011JAN" VALUES LESS THAN (TO_DATE('2011-02-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JAN )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JAN )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JAN )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JAN )

TABLESPACE CM_F1T191_P2011JAN,

PARTITION "P2011FEB" VALUES LESS THAN (TO_DATE('2011-03-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011FEB )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011FEB )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011FEB )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011FEB )

TABLESPACE CM_F1T191_P2011FEB,

PARTITION "P2011MAR" VALUES LESS THAN (TO_DATE('2011-04-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAR )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAR )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAR )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAR )

TABLESPACE CM_F1T191_P2011MAR,

PARTITION "P2011APR" VALUES LESS THAN (TO_DATE('2011-05-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011APR )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011APR )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011APR )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011APR )

TABLESPACE CM_F1T191_P2011APR,

PARTITION "P2011MAY" VALUES LESS THAN (TO_DATE('2011-06-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAY )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAY )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAY )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011MAY )

TABLESPACE CM_F1T191_P2011MAY,

PARTITION "P2011JUN" VALUES LESS THAN (TO_DATE('2011-07-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUN )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUN )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUN )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUN )

TABLESPACE CM_F1T191_P2011JUN,

PARTITION "P2011JUL" VALUES LESS THAN (TO_DATE('2011-08-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUL )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUL )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUL )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011JUL )

TABLESPACE CM_F1T191_P2011JUL,

PARTITION "P2011AUG" VALUES LESS THAN (TO_DATE('2011-09-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011AUG )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011AUG )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011AUG )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011AUG )

TABLESPACE CM_F1T191_P2011AUG,

PARTITION "P2011SEP" VALUES LESS THAN (TO_DATE('2011-10-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011SEP )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011SEP )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011SEP )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011SEP )

TABLESPACE CM_F1T191_P2011SEP,

PARTITION "P2011OCT" VALUES LESS THAN (TO_DATE('2011-11-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011OCT )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011OCT )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011OCT )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011OCT )

TABLESPACE CM_F1T191_P2011OCT,

PARTITION "P2011NOV" VALUES LESS THAN (TO_DATE('2011-12-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011NOV )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011NOV )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011NOV )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011NOV )

TABLESPACE CM_F1T191_P2011NOV,

PARTITION "P2011DEC" VALUES LESS THAN (TO_DATE('2012-01-01 00:00:01', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011DEC )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011DEC )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011DEC )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_P2011DEC )

TABLESPACE CM_F1T191_P2011DEC,

PARTITION "PMAX" VALUES LESS THAN (MAXVALUE)

LOB(BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_PMAX )

LOB(PRE_TRN_INIT_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_PMAX )

LOB(PRE_TRN_FIN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_PMAX )

LOB(POST_TRN_BO_DATA_AREA) STORE AS SECUREFILE (ENABLE STORAGE IN ROW COMPRESS MEDIUM CACHE TABLESPACE CM_F1T191_PMAX )

TABLESPACE CM_F1T191_PMAX

);

CREATE BIGFILE TABLESPACE CM_F1T191_IND DATAFILE '+DATADG' SIZE 50M AUTOEXTEND ON MAXSIZE UNLIMITED DEFAULT ROW STORE COMPRESS ADVANCED;

 

CREATE UNIQUE INDEX F1T191P0 ON F1_SYNC_REQ_IN(F1_SYNC_REQ_IN_ID) TABLESPACE CM_F1T191_IND

GLOBAL PARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

(

PARTITION P1 VALUES LESS THAN ( '12499999999999' ),

PARTITION P2 VALUES LESS THAN ( '24999999999999' ),

PARTITION P3 VALUES LESS THAN ( '37499999999999' ),

PARTITION P4 VALUES LESS THAN ( '49999999999999' ),

PARTITION P5 VALUES LESS THAN ( '62499999999999' ),

PARTITION P6 VALUES LESS THAN ( '74999999999999' ),

PARTITION P7 VALUES LESS THAN ( '87499999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

);

 

ALTER TABLE F1_SYNC_REQ_IN ADD CONSTRAINT F1T191P0 PRIMARY KEY (F1_SYNC_REQ_IN_ID) USING INDEX;

 

CREATE UNIQUE INDEX F1T191S1 ON F1_SYNC_REQ_IN (BO_STATUS_CD, BUS_OBJ_CD, F1_SYNC_REQ_IN_ID) TABLESPACE CM_F1T191_IND COMPRESS ADVANCED LOW;

 

CREATE INDEX F1T191S2 ON F1_SYNC_REQ_IN(MAINT_OBJ_CD,EXT_PK_VALUE1,NT_XID_CD,PK_VALUE1) TABLESPACE CM_F1T191_IND COMPRESS ADVANCED LOW;

 

CREATE INDEX F1T191S3 ON F1_SYNC_REQ_IN(EXT_REFERENCE_ID) TABLESPACE CM_F1T191_IND;

CREATE UNIQUE INDEX CM_ILM_F1T191S3 ON F1_SYNC_REQ_IN(ILM_DT, ILM_ARCH_SW, F1_SYNC_REQ_IN_ID) LOCAL COMPRESS ADVANCED LOW;

CREATE TABLE F1_SYNC_REQ_IN_CHAR

(

F1_SYNC_REQ_IN_ID CHAR(14) NOT NULL ENABLE,

CHAR_TYPE_CD CHAR(8) NOT NULL ENABLE,

SEQ_NUM NUMBER(3,0) NOT NULL ENABLE,

CHAR_VAL CHAR(16) DEFAULT ' ' NOT NULL ENABLE,

ADHOC_CHAR_VAL VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK1 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK2 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK3 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK4 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK5 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

SRCH_CHAR_VAL VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT F1_SYNC_REQ_IN_CHAR_FK FOREIGN KEY(F1_SYNC_REQ_IN_ID) REFERENCES F1_SYNC_REQ_IN ON DELETE CASCADE)

PARTITION BY REFERENCE (F1_SYNC_REQ_IN_CHAR_FK)

ENABLE ROW MOVEMENT;

CREATE UNIQUE INDEX F1T193P0 ON F1_SYNC_REQ_IN_CHAR(F1_SYNC_REQ_IN_ID, CHAR_TYPE_CD, SEQ_NUM) TABLESPACE CM_F1T191_IND

GLOBAL PARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

(

PARTITION P1 VALUES LESS THAN ( '12499999999999' ),

PARTITION P2 VALUES LESS THAN ( '24999999999999' ),

PARTITION P3 VALUES LESS THAN ( '37499999999999' ),

PARTITION P4 VALUES LESS THAN ( '49999999999999' ),

PARTITION P5 VALUES LESS THAN ( '62499999999999' ),

PARTITION P6 VALUES LESS THAN ( '74999999999999' ),

PARTITION P7 VALUES LESS THAN ( '87499999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW;

ALTER TABLE F1_SYNC_REQ_IN_CHAR ADD CONSTRAINT F1T193P0 PRIMARY KEY (F1_SYNC_REQ_IN_ID, CHAR_TYPE_CD, SEQ_NUM) USING INDEX;

 

CREATE INDEX F1T193S1 ON F1_SYNC_REQ_IN_CHAR(SRCH_CHAR_VAL) TABLESPACE CM_F1T191_IND ;

CREATE TABLE F1_SYNC_REQ_IN_EXCP

(

F1_SYNC_REQ_IN_ID CHAR(14) NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

MESSAGE_CAT_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,

MESSAGE_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT F1_SYNC_REQ_IN_EXCP_FK FOREIGN KEY(F1_SYNC_REQ_IN_ID) REFERENCES F1_SYNC_REQ_IN ON DELETE CASCADE)

PARTITION BY REFERENCE (F1_SYNC_REQ_IN_EXCP_FK)

ENABLE ROW MOVEMENT;

CREATE UNIQUE INDEX F1T197P0 ON F1_SYNC_REQ_IN_EXCP(F1_SYNC_REQ_IN_ID,SEQNO) TABLESPACE CM_F1T191_IND

GLOBAL PARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

(

PARTITION P1 VALUES LESS THAN ( '12499999999999' ),

PARTITION P2 VALUES LESS THAN ( '24999999999999' ),

PARTITION P3 VALUES LESS THAN ( '37499999999999' ),

PARTITION P4 VALUES LESS THAN ( '49999999999999' ),

PARTITION P5 VALUES LESS THAN ( '62499999999999' ),

PARTITION P6 VALUES LESS THAN ( '74999999999999' ),

PARTITION P7 VALUES LESS THAN ( '87499999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW;

 

ALTER TABLE F1_SYNC_REQ_IN_EXCP ADD CONSTRAINT F1T197P0 PRIMARY KEY (F1_SYNC_REQ_IN_ID,SEQNO) USING INDEX;

CREATE TABLE F1_SYNC_REQ_IN_EXCP_PARM

(

F1_SYNC_REQ_IN_ID CHAR(14) NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

PARM_SEQ NUMBER(3,0) NOT NULL ENABLE,

MSG_PARM_VAL VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MSG_PARM_TYP_FLG CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT F1_SYNC_REQ_IN_EXCP_PARM_FK FOREIGN KEY(F1_SYNC_REQ_IN_ID) REFERENCES F1_SYNC_REQ_IN ON DELETE CASCADE)

PARTITION BY REFERENCE (F1_SYNC_REQ_IN_EXCP_PARM_FK)

ENABLE ROW MOVEMENT;

 

CREATE UNIQUE INDEX F1T198P0 ON F1_SYNC_REQ_IN_EXCP_PARM(F1_SYNC_REQ_IN_ID,SEQNO,PARM_SEQ) TABLESPACE CM_F1T191_IND

GLOBAL PARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

(

PARTITION P1 VALUES LESS THAN ( '12499999999999' ),

PARTITION P2 VALUES LESS THAN ( '24999999999999' ),

PARTITION P3 VALUES LESS THAN ( '37499999999999' ),

PARTITION P4 VALUES LESS THAN ( '49999999999999' ),

PARTITION P5 VALUES LESS THAN ( '62499999999999' ),

PARTITION P6 VALUES LESS THAN ( '74999999999999' ),

PARTITION P7 VALUES LESS THAN ( '87499999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW;

 

ALTER TABLE F1_SYNC_REQ_IN_EXCP_PARM ADD CONSTRAINT F1T198P0 PRIMARY KEY (F1_SYNC_REQ_IN_ID,SEQNO,PARM_SEQ) USING INDEX;

CREATE TABLE F1_SYNC_REQ_IN_LOG

(

F1_SYNC_REQ_IN_ID CHAR(14) NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

LOG_ENTRY_TYPE_FLG CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

LOG_DTTM DATE NOT NULL ENABLE,

BO_STATUS_CD CHAR(12) DEFAULT ' ' NOT NULL ENABLE,

MESSAGE_CAT_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,

MESSAGE_NBR NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE,

CHAR_TYPE_CD CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL CHAR(16) DEFAULT ' ' NOT NULL ENABLE,

ADHOC_CHAR_VAL VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK1 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK2 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK3 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK4 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

CHAR_VAL_FK5 VARCHAR2(50) DEFAULT ' ' NOT NULL ENABLE,

DESCRLONG VARCHAR2(4000) DEFAULT ' ' NOT NULL ENABLE,

USER_ID CHAR(8) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT F1_SYNC_REQ_IN_LOG_FK FOREIGN KEY(F1_SYNC_REQ_IN_ID) REFERENCES F1_SYNC_REQ_IN ON DELETE CASCADE)

PARTITION BY REFERENCE (F1_SYNC_REQ_IN_LOG_FK)

ENABLE ROW MOVEMENT;

CREATE UNIQUE INDEX F1T194P0 ON F1_SYNC_REQ_IN_LOG(F1_SYNC_REQ_IN_ID,SEQNO) TABLESPACE CM_F1T191_IND

GLOBAL PARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

(

PARTITION P1 VALUES LESS THAN ( '12499999999999' ),

PARTITION P2 VALUES LESS THAN ( '24999999999999' ),

PARTITION P3 VALUES LESS THAN ( '37499999999999' ),

PARTITION P4 VALUES LESS THAN ( '49999999999999' ),

PARTITION P5 VALUES LESS THAN ( '62499999999999' ),

PARTITION P6 VALUES LESS THAN ( '74999999999999' ),

PARTITION P7 VALUES LESS THAN ( '87499999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW;

 

ALTER TABLE F1_SYNC_REQ_IN_LOG ADD CONSTRAINT F1T194P0 PRIMARY KEY (F1_SYNC_REQ_IN_ID,SEQNO) USING INDEX;

 

CREATE INDEX F1T194S1 ON F1_SYNC_REQ_IN_LOG(CHAR_TYPE_CD,CHAR_VAL_FK1) TABLESPACE CM_F1T191_IND COMPRESS ADVANCED LOW;

 

CREATE INDEX F1T194S2 ON F1_SYNC_REQ_IN_LOG(CHAR_TYPE_CD,CHAR_VAL) TABLESPACE CM_F1T191_IND COMPRESS ADVANCED LOW;

CREATE TABLE F1_SYNC_REQ_IN_LOG_PARM

(

F1_SYNC_REQ_IN_ID CHAR(14) NOT NULL ENABLE,

SEQNO NUMBER(5,0) NOT NULL ENABLE,

PARM_SEQ NUMBER(3,0) NOT NULL ENABLE,

MSG_PARM_VAL VARCHAR2(2000) DEFAULT ' ' NOT NULL ENABLE,

MSG_PARM_TYP_FLG CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT F1_SYNC_REQ_IN_LOG_PARM_FK FOREIGN KEY(F1_SYNC_REQ_IN_ID) REFERENCES F1_SYNC_REQ_IN ON DELETE CASCADE)

PARTITION BY REFERENCE (F1_SYNC_REQ_IN_LOG_PARM_FK)

ENABLE ROW MOVEMENT;

CREATE UNIQUE INDEX F1T195P0 ON F1_SYNC_REQ_IN_LOG_PARM(F1_SYNC_REQ_IN_ID,SEQNO,PARM_SEQ) TABLESPACE CM_F1T191_IND

GLOBAL PARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

(

PARTITION P1 VALUES LESS THAN ( '12499999999999' ),

PARTITION P2 VALUES LESS THAN ( '24999999999999' ),

PARTITION P3 VALUES LESS THAN ( '37499999999999' ),

PARTITION P4 VALUES LESS THAN ( '49999999999999' ),

PARTITION P5 VALUES LESS THAN ( '62499999999999' ),

PARTITION P6 VALUES LESS THAN ( '74999999999999' ),

PARTITION P7 VALUES LESS THAN ( '87499999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW;

 

ALTER TABLE F1_SYNC_REQ_IN_LOG_PARM ADD CONSTRAINT F1T195P0 PRIMARY KEY (F1_SYNC_REQ_IN_ID,SEQNO,PARM_SEQ) USING INDEX;

CREATE TABLE F1_SYNC_REQ_IN_REL_OBJ

(

F1_SYNC_REQ_IN_ID CHAR(14) NOT NULL ENABLE,

MAINT_OBJ_CD CHAR(12) DEFAULT ' ' NOT NULL ENABLE,

REL_OBJ_TYPE_FLG CHAR(4) DEFAULT ' ' NOT NULL ENABLE,

PK_VALUE1 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

PK_VALUE2 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

PK_VALUE3 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

PK_VALUE4 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

PK_VALUE5 VARCHAR2(254) DEFAULT ' ' NOT NULL ENABLE,

VERSION NUMBER(5,0) DEFAULT 1 NOT NULL ENABLE,

CONSTRAINT F1_SYNC_REQ_IN_REL_OBJ_FK FOREIGN KEY(F1_SYNC_REQ_IN_ID) REFERENCES F1_SYNC_REQ_IN ON DELETE CASCADE)

PARTITION BY REFERENCE (F1_SYNC_REQ_IN_REL_OBJ_FK)

ENABLE ROW MOVEMENT;

 

CREATE UNIQUE INDEX F1T192P0 ON F1_SYNC_REQ_IN_REL_OBJ(F1_SYNC_REQ_IN_ID, MAINT_OBJ_CD, REL_OBJ_TYPE_FLG) TABLESPACE CM_F1T191_IND

GLOBAL PARTITION BY RANGE (F1_SYNC_REQ_IN_ID)

(

PARTITION P1 VALUES LESS THAN ( '12499999999999' ),

PARTITION P2 VALUES LESS THAN ( '24999999999999' ),

PARTITION P3 VALUES LESS THAN ( '37499999999999' ),

PARTITION P4 VALUES LESS THAN ( '49999999999999' ),

PARTITION P5 VALUES LESS THAN ( '62499999999999' ),

PARTITION P6 VALUES LESS THAN ( '74999999999999' ),

PARTITION P7 VALUES LESS THAN ( '87499999999999' ),

PARTITION P8 VALUES LESS THAN ( MAXVALUE )

)

COMPRESS ADVANCED LOW;

 

ALTER TABLE F1_SYNC_REQ_IN_REL_OBJ ADD CONSTRAINT F1T192P0 PRIMARY KEY (F1_SYNC_REQ_IN_ID, MAINT_OBJ_CD, REL_OBJ_TYPE_FLG) USING INDEX;

 

CREATE INDEX F1T192S1 ON F1_SYNC_REQ_IN_REL_OBJ(PK_VALUE1) TABLESPACE CM_F1T191_IND;