【产品名称】Ocean Base
【产品版本】2.2.76
【问题描述】带主键constraint的ddl创建的表,不支持local选项
建表语句
CREATE TABLE “PM_PROM_ITEMTYPE_RANK_EX_HIS”
( “SEQ_ID” NUMBER(20) NOT NULL,
“RANK_OFFERING_ROUTE” VARCHAR2(1024),
“MODIFY_TIME” DATE NOT NULL,
“ITEM_TYPE_CODE” VARCHAR2(64) NOT NULL,
CONSTRAINT “PK_PROM_ITEMTYPE_RANK_EX_HIS” PRIMARY KEY (“SEQ_ID”, “MODIFY_TIME”) using index LOCAL
) TABLESPACE “TBS_PM_DAT”
PARTITION BY RANGE(“MODIFY_TIME”)
( PARTITION “P20170601” VALUES LESS THAN (TO_DATE(’ 2017-06-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)) TABLESPACE “TBS_PM_DAT”,
PARTITION “P202012” VALUES LESS THAN (TO_DATE(’ 2021-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’)) TABLESPACE “TBS_PM_DAT”);
实际效果
PK_PROM_ITEMTYPE_RANK_EX_HIS为NORMAL LOCAL的