【 使用环境 】生产环境
【 OB or 其他组件 】
【 使用版本 】4.2.0
表结构：
CREATE TABLE “TAECNDA1”.“TAE_ACCT_MAINTRADES” (
“MAIN_ID” VARCHAR2(80 CHAR) CONSTRAINT “TAE_ACCT_MAINTRADES_OBNOTNULL_1700038567671021” NOT NULL ENABLE,
“TXN_BRAN_NO” VARCHAR2(12 CHAR) CONSTRAINT “TAE_ACCT_MAINTRADES_OBNOTNULL_1700038567671031” NOT NULL ENABLE,
“TXN_OPER_NO” VARCHAR2(12 CHAR),
“CHNL_ID” VARCHAR2(20 CHAR) CONSTRAINT “TAE_ACCT_MAINTRADES_OBNOTNULL_1700038567671035” NOT NULL ENABLE,
“CHNL_SEQ” VARCHAR2(50 CHAR) CONSTRAINT “TAE_ACCT_MAINTRADES_OBNOTNULL_1700038567671038” NOT NULL ENABLE,
“CHNL_DATE” DATE CONSTRAINT “TAE_ACCT_MAINTRADES_OBNOTNULL_1700038567671041” NOT NULL ENABLE,
“ACCT_DATE” DATE CONSTRAINT “TAE_ACCT_MAINTRADES_OBNOTNULL_1700038567671045” NOT NULL ENABLE,
“SETTLE_DATE” DATE,
“CASH_TRANS_FLAG” VARCHAR2(1 CHAR),
CONSTRAINT “SYS_C0095620” UNIQUE (“MAIN_ID”)
) COMPRESS FOR ARCHIVE REPLICA_NUM = 1 BLOCK_SIZE = 16384 USE_BLOOM_FILTER = FALSE TABLET_SIZE = 134217728 PCTFREE = 0
partition by range(“CHNL_DATE”) INTERVAL (INTERVAL ‘+000000000-01’ YEAR (9) TO MONTH)
(partition SYS_P3369 values less than (TO_DATE(’ 2025-12-25 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)),
partition SYS_P3939 values less than (TO_DATE(’ 2026-03-25 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)));
