为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:可以先把表建好,再进行分区的设置吗
CREATE TABLE "sbww"."T_PART"
(
"ID" INT,
"NAME" VARCHAR2(50),
"AGE" INT,
"CREATE_TIME" DATE,
"DEPTNO" INT
)
PARTITION BY RANGE("CREATE_TIME", "AGE")
(PARTITION "P1" VALUES LESS THAN (DATE'2000-01-01',30),
PARTITION "P2" VALUES LESS THAN (DATE'2000-01-01',40),
PARTITION "P3" VALUES LESS THAN (DATE'2000-01-01',50),
PARTITION "P4" VALUES LESS THAN (DATE'2000-01-01',60),
PARTITION "P5" VALUES LESS THAN (DATE'2000-01-01',70),
PARTITION "P6" VALUES LESS THAN (DATE'2000-01-01',80),
PARTITION "P_MAX" VALUES LESS THAN (DATE'2000-01-01',MAXVALUE)
)
上述的这样是可以直接创建ok的,
我想问一下
我先CREATE TABLE "sbww"."T_PART"
(
"ID" INT,
"NAME" VARCHAR2(50),
"AGE" INT,
"CREATE_TIME" DATE,
"DEPTNO" INT
);
把表创建好,我再去添加分区信息 我该怎么添加呢 语法是怎么样的? 是这样吗?
ALTER TABLE "sbww"."T_PART"
PARTITION BY RANGE("CREATE_TIME", "AGE")
(PARTITION "P1" VALUES LESS THAN (DATE'2000-01-01',30),
PARTITION "P2" VALUES LESS THAN (DATE'2000-01-01',40),
PARTITION "P3" VALUES LESS THAN (DATE'2000-01-01',50),
PARTITION "P4" VALUES LESS THAN (DATE'2000-01-01',60),
PARTITION "P5" VALUES LESS THAN (DATE'2000-01-01',70),
PARTITION "P6" VALUES LESS THAN (DATE'2000-01-01',80),
PARTITION "P_MAX" VALUES LESS THAN (DATE'2000-01-01',MAXVALUE)
);
分区表只能创建的时候定义为分区表
不可以,需要在建表的时候就制定为分区表。