ALTER TABLE ADMIN.DATA_TEMP
DROP PRIMARY KEY CASCADE;
DROP TABLE ADMIN.DATA_TEMP_ CASCADE CONSTRAINTS;
CREATE TABLE ADMIN.DATA_TEMP_
(
MODEL_CONFIG_RAWID NUMBER(20) NOT NULL,
SPC_DATA_DTTS TIMESTAMP(6) NOT NULL,
CONTEXT_LIST VARCHAR2(4000 BYTE),
CONTEXT_LIST1 VARCHAR2(4000 BYTE),
CONTEXT_LIST2 VARCHAR2(4000 BYTE),
CONTEXT_LIST3 VARCHAR2(4000 BYTE),
CONTEXT_LIST4 VARCHAR2(4000 BYTE),
CONTEXT_LIST5 CLOB,
DATA_LIST VARCHAR2(4000 BYTE),
DATA_LIST1 VARCHAR2(4000 BYTE),
DATA_LIST2 VARCHAR2(4000 BYTE),
DATA_LIST3 VARCHAR2(4000 BYTE),
DATA_LIST4 VARCHAR2(4000 BYTE),
DATA_LIST5 CLOB,
WEEKDAY VARCHAR2(1 BYTE) DEFAULT TO_CHAR(SYSDATE,'D') NOT NULL
)
LOB (CONTEXT_LIST5) STORE AS DATA_TEMP__CONTEXT_LOB (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS DATA_TEMP_DATA_LOB (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
TABLESPACE SPC_TMP_DAT
PCTUSED 0
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
NOLOGGING
PARTITION BY RANGE (WEEKDAY)
SUBPARTITION BY HASH (MODEL_CONFIG_RAWID)
SUBPARTITION TEMPLATE
(SUBPARTITION SP01
LOB (CONTEXT_LIST5) STORE AS SP01 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP01 (TABLESPACE ),
SUBPARTITION SP02
LOB (CONTEXT_LIST5) STORE AS SP02 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP02 (TABLESPACE ),
SUBPARTITION SP03
LOB (CONTEXT_LIST5) STORE AS SP03 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP03 (TABLESPACE ),
SUBPARTITION SP04
LOB (CONTEXT_LIST5) STORE AS SP04 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP04 (TABLESPACE ),
SUBPARTITION SP05
LOB (CONTEXT_LIST5) STORE AS SP05 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP05 (TABLESPACE ),
SUBPARTITION SP06
LOB (CONTEXT_LIST5) STORE AS SP06 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP06 (TABLESPACE ),
SUBPARTITION SP07
LOB (CONTEXT_LIST5) STORE AS SP07 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP07 (TABLESPACE ),
SUBPARTITION SP08
LOB (CONTEXT_LIST5) STORE AS SP08 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP08 (TABLESPACE ),
SUBPARTITION SP09
LOB (CONTEXT_LIST5) STORE AS SP09 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP09 (TABLESPACE ),
SUBPARTITION SP10
LOB (CONTEXT_LIST5) STORE AS SP10 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP10 (TABLESPACE ),
SUBPARTITION SP11
LOB (CONTEXT_LIST5) STORE AS SP11 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP11 (TABLESPACE ),
SUBPARTITION SP12
LOB (CONTEXT_LIST5) STORE AS SP12 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP12 (TABLESPACE ),
SUBPARTITION SP13
LOB (CONTEXT_LIST5) STORE AS SP13 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP13 (TABLESPACE ),
SUBPARTITION SP14
LOB (CONTEXT_LIST5) STORE AS SP14 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP14 (TABLESPACE ),
SUBPARTITION SP15
LOB (CONTEXT_LIST5) STORE AS SP15 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP15 (TABLESPACE ),
SUBPARTITION SP16
LOB (CONTEXT_LIST5) STORE AS SP16 (TABLESPACE )
LOB (DATA_LIST5) STORE AS SP16 (TABLESPACE )
)
(
PARTITION P01 VALUES LESS THAN ('2')
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_DAT
LOB (CONTEXT_LIST5) STORE AS P01 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS P01 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P01_SP01 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP02 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP03 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP04 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP05 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP06 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP07 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP08 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP09 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP10 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP11 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP12 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP13 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP14 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP15 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P01_SP16 TABLESPACE SPC_TMP_DAT ),
PARTITION P02 VALUES LESS THAN ('3')
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_DAT
LOB (CONTEXT_LIST5) STORE AS P02 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS P02 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P02_SP01 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP02 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP03 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP04 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP05 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP06 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP07 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP08 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP09 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP10 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP11 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP12 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP13 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP14 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP15 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P02_SP16 TABLESPACE SPC_TMP_DAT ),
PARTITION P03 VALUES LESS THAN ('4')
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_DAT
LOB (CONTEXT_LIST5) STORE AS P03 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS P03 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P03_SP01 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP02 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP03 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP04 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP05 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP06 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP07 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP08 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP09 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP10 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP11 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP12 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP13 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP14 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP15 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P03_SP16 TABLESPACE SPC_TMP_DAT ),
PARTITION P04 VALUES LESS THAN ('5')
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_DAT
LOB (CONTEXT_LIST5) STORE AS P04 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS P04 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P04_SP01 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP02 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP03 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP04 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP05 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP06 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP07 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP08 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP09 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP10 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP11 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP12 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP13 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP14 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP15 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P04_SP16 TABLESPACE SPC_TMP_DAT ),
PARTITION P05 VALUES LESS THAN ('6')
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_DAT
LOB (CONTEXT_LIST5) STORE AS P05 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS P05 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P05_SP01 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP02 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP03 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP04 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP05 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP06 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP07 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP08 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP09 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP10 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP11 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP12 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP13 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP14 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP15 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P05_SP16 TABLESPACE SPC_TMP_DAT ),
PARTITION P06 VALUES LESS THAN ('7')
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_DAT
LOB (CONTEXT_LIST5) STORE AS P06 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS P06 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P06_SP01 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP02 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP03 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP04 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP05 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP06 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP07 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP08 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP09 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP10 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP11 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP12 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP13 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP14 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP15 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P06_SP16 TABLESPACE SPC_TMP_DAT ),
PARTITION P07 VALUES LESS THAN ('8')
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_DAT
LOB (CONTEXT_LIST5) STORE AS P07 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
LOB (DATA_LIST5) STORE AS P07 (
TABLESPACE SPC_TMP_DAT
ENABLE STORAGE IN ROW
CHUNK 8192
RETENTION
NOCACHE
NOLOGGING)
PCTFREE 0
INITRANS 1
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P07_SP01 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP02 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP03 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP04 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP05 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP06 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP07 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP08 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP09 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP10 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP11 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP12 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP13 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP14 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP15 TABLESPACE SPC_TMP_DAT,
SUBPARTITION P07_SP16 TABLESPACE SPC_TMP_DAT )
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING
ENABLE ROW MOVEMENT;
CREATE UNIQUE INDEX FADMIN.IDX_DATA_TEMP_PK ON FADMIN.DATA_TEMP
(MODEL_CONFIG_RAWID, SPC_DATA_DTTS, CREATE_DTTS, WEEKDAY)
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
NOLOGGING
LOCAL (
PARTITION P01
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P01_SP01 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP02 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP03 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP04 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP05 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP06 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP07 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP08 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP09 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP10 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP11 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP12 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP13 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP14 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP15 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P01_SP16 TABLESPACE SPC_TMP_IDX ),
PARTITION P02
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P02_SP01 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP02 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP03 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP04 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP05 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP06 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP07 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP08 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP09 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP10 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP11 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP12 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP13 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP14 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP15 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P02_SP16 TABLESPACE SPC_TMP_IDX ),
PARTITION P03
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P03_SP01 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP02 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP03 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP04 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP05 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP06 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP07 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP08 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP09 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP10 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP11 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP12 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP13 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP14 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP15 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P03_SP16 TABLESPACE SPC_TMP_IDX ),
PARTITION P04
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P04_SP01 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP02 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP03 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP04 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP05 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP06 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP07 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP08 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP09 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP10 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP11 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP12 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP13 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP14 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP15 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P04_SP16 TABLESPACE SPC_TMP_IDX ),
PARTITION P05
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P05_SP01 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP02 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP03 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP04 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP05 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP06 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP07 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP08 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP09 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP10 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP11 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP12 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP13 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP14 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP15 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P05_SP16 TABLESPACE SPC_TMP_IDX ),
PARTITION P06
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P06_SP01 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP02 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP03 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP04 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP05 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP06 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP07 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP08 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP09 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP10 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP11 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP12 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP13 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP14 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP15 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P06_SP16 TABLESPACE SPC_TMP_IDX ),
PARTITION P07
NOLOGGING
NOCOMPRESS
TABLESPACE SPC_TMP_IDX
PCTFREE 0
INITRANS 5
MAXTRANS 255
STORAGE (
BUFFER_POOL DEFAULT
)
( SUBPARTITION P07_SP01 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP02 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP03 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP04 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP05 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP06 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP07 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP08 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP09 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP10 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP11 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP12 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP13 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP14 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP15 TABLESPACE SPC_TMP_IDX,
SUBPARTITION P07_SP16 TABLESPACE SPC_TMP_IDX )
)
NOPARALLEL;
ALTER TABLE ADMIN.DATA_TEMP ADD (
CONSTRAINT IDX_DATA_TEMP_PK
PRIMARY KEY
(MODEL_CONFIG_RAWID, SPC_DATA_DTTS, CREATE_DTTS, WEEKDAY)
USING INDEX LOCAL);