--如果没有数据,选择重建表,并添加‘interval (numtoyminterval(1,'month'))’自动分区
create table TB_TEST_ZH
(
XM VARCHAR2(64) not null,
NL VARCHAR2(36) not null,
PART VARCHAR2(22) not null,
TIME DATE not null
)
partition by range (TIME)interval (numtoyminterval(1,'month'))
(partition p_init values less than (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')))
ORA-14400: 插入的分区关键字未映射到任何分区
最新推荐文章于 2021-04-04 04:01:46 发布