Oracle动态创建时间分区，以及Oracle12c中快速创建自增列

create table APDEMO
(
OID NUMBER(38) generated as identity (start with 1 increment by 1),--主键，自增列
REPORTTIME DATE , 
AP_MAC VARCHAR2(64 CHAR) , 
APALIASNAME VARCHAR2(128 CHAR) not null, 
HOTSPOTNAME VARCHAR2(128 CHAR) not null, 
LONGITUDE VARCHAR2(64 CHAR) , 
CITY VARCHAR2(50 CHAR) not null,
constraint pk_APDEMO_OID primary key (OID)
)
partition by range(REPORTTIME) interval (numtodsinterval(1,‘day‘))
(
partition part_20170101 values less than (to_date(‘20170101‘,‘yyyyMMdd‘))   --这里需要加入一个起始日期
);