CREATE TABLE P_CARDMST
(
PID VARCHAR2(20 BYTE) NOT NULL,
CONTNO VARCHAR2(15 BYTE),
STATUS VARCHAR2(10 BYTE),
ISSUESEQ NUMBER(8),
ISSUEDT DATE,
ISSUE_USER VARCHAR2(10 BYTE),
PRICEPLAN VARCHAR2(10 BYTE),
PRICEMODEL VARCHAR2(10 BYTE),
LOTNO VARCHAR2(20 BYTE),
OUTSEQ NUMBER(8),
OPENDT DATE,
ENDDT DATE,
OPENUSEDT DATE,
LASTUSEDT DATE,
REFILLSUM_AMT NUMBER(14,2),
USEDSUM_AMT NUMBER(14,2),
SALESUM_AMT NUMBER(14,2),
BALANCE NUMBER(14,2),
LAST_USE_AMT NUMBER(14,2),
FIRST_REFILL_AMT NUMBER(14,2),
FIRST_SALE_AMT NUMBER(14,2),
LAST_REFILL_AMT NUMBER(14,2),
LAST_REFILLDT DATE,
REFILL_YN VARCHAR2(10 BYTE),
CARD_MARKER VARCHAR2(10 BYTE),
ORDERDT DATE,
INDT DATE,
PARTNER_PREFIX VARCHAR2(60 BYTE),
MOVESEQ NUMBER(8),
MOVEDT DATE,
SALE_FLAG VARCHAR2(1 BYTE),
REMARK VARCHAR2(60 BYTE),
WKFLAG1 VARCHAR2(10 BYTE) DEFAULT 'B',
WKFLAG2 VARCHAR2(10 BYTE),
WKFLAG3 VARCHAR2(10 BYTE),
BILPOINT NUMBER(14,2),
PASSWD_YN VARCHAR2(1 BYTE) DEFAULT 'N',
PASSWD VARCHAR2(20 BYTE),
CRTDT DATE,
CRT_USER VARCHAR2(10 BYTE),
UPDTDT DATE,
UPDT_USER VARCHAR2(10 BYTE),
PGM_ID VARCHAR2(8 BYTE),
GRACE_DT DATE,
CALL_USED_DT DATE,
MDN_NO VARCHAR2(16 BYTE),
ENCRYPT_PIN VARCHAR2(60 BYTE),
LOCATION_CODE VARCHAR2(4 BYTE),
END_PERIOD NUMBER(4),
GRACE_PERIOD NUMBER(4),
CALL_USED_PERIOD NUMBER(4),
VQS_STATUS CHAR(1 BYTE)
)
PARTITION BY RANGE (contno)
(
PARTITION PT_CONT001 VALUES LESS THAN ('100001000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT002 VALUES LESS THAN ('100002000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT003 VALUES LESS THAN ('100003000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT004 VALUES LESS THAN ('100004000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT005 VALUES LESS THAN ('100005000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT006 VALUES LESS THAN ('100006000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT007 VALUES LESS THAN ('100007000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT008 VALUES LESS THAN ('100008000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT009 VALUES LESS THAN ('100009000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT010 VALUES LESS THAN ('100010000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT011 VALUES LESS THAN ('100011000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT012 VALUES LESS THAN ('100012000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT013 VALUES LESS THAN ('100013000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT014 VALUES LESS THAN ('100014000000') LOGGING NOCOMPRESS,
PARTITION PT_CONT015 VALUES LESS THAN ('100015000000') LOGGING NOCOMPRESS
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
CREATE INDEX IDX_P_CARDMST ON P_CARDMST
(CONTNO, PID )
LOCAL (
PARTITION PT_CONT001 LOGGING NOCOMPRESS,
PARTITION PT_CONT002 LOGGING NOCOMPRESS,
PARTITION PT_CONT003 LOGGING NOCOMPRESS,
PARTITION PT_CONT004 LOGGING NOCOMPRESS,
PARTITION PT_CONT005 LOGGING NOCOMPRESS,
PARTITION PT_CONT006 LOGGING NOCOMPRESS,
PARTITION PT_CONT007 LOGGING NOCOMPRESS,
PARTITION PT_CONT008 LOGGING NOCOMPRESS,
PARTITION PT_CONT009 LOGGING NOCOMPRESS,
PARTITION PT_CONT010 LOGGING NOCOMPRESS,
PARTITION PT_CONT011 LOGGING NOCOMPRESS,
PARTITION PT_CONT012 LOGGING NOCOMPRESS,
PARTITION PT_CONT013 LOGGING NOCOMPRESS,
PARTITION PT_CONT014 LOGGING NOCOMPRESS,
PARTITION PT_CONT015 LOGGING NOCOMPRESS
);
