oracle 创建按日期自动分区表

https://www.cnblogs.com/gongshun/p/10620252.html

 

create table t_xxx
(
xxx_name VARCHAR2(35) not null,
xxx_result VARCHAR2(35),
xxx_time DATE,
xxx_user VARCHAR2(35),
xxxx_user VARCHAR2(35)
)
partition by range (UPDATE_TIME)INTERVAL (numtoyminterval(1, 'month'))
(
partition PART_T01 values less than (TO_DATE(' 2021-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
tablespace xxx_INFO
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 8M
next 1M
minextents 1
maxextents unlimited
)
);
-- Create/Recreate primary, unique and foreign key constraints
alter table t_xxx
add constraint t_xxx_PK primary key (xxx_name )
using index
tablespace xxx_INFO
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
alter table t_xxx enable row movement;