oracle表分区的使用 - 折雨的天空

先来几个参考地址：http://blog.csdn.net/qq_29663071/article/details/51557802http://blog.csdn.net/sdtysdu2000/article/details/9066413http://blog.csdn.net/chichuduxing/article/details/68490822...

先来几个参考地址：

http://blog.csdn.net/qq_29663071/article/details/51557802

http://blog.csdn.net/sdtysdu2000/article/details/9066413

http://blog.csdn.net/chichuduxing/article/details/68490822

https://www.cnblogs.com/aqsunkai/p/6832502.html

http://blog.csdn.net/mzglzzc/article/details/46300645

按周分区的

CREATE TABLE "WOLF_RPHIS"."API_LOGS_DETAIL" 
   (	"UUID" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
	"ORG_ID" VARCHAR2(100 BYTE), 
	"COMPANY_ID" VARCHAR2(100 BYTE), 
	"CREATED" VARCHAR2(20 BYTE), 
	"API_RESOURCE_UUID" VARCHAR2(100 BYTE), 
	"IDENTITY_NUMBER" VARCHAR2(100 BYTE), 
	"EXT_UUID" VARCHAR2(100 BYTE), 
	"RESULTS" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(2400 BYTE), 
	"TYPE" VARCHAR2(20 BYTE) NOT NULL ENABLE, 
	"CODE" VARCHAR2(100 BYTE) NOT NULL ENABLE, 
	"SUUID" VARCHAR2(100 BYTE), 
	"SANYI_STATUS" VARCHAR2(2 BYTE) NOT NULL ENABLE,
	"PARTION_DATE" DATE DEFAULT SYSDATE NOT NULL
   ) partition by range(PARTION_DATE)  
INTERVAL(NUMTODSINTERVAL(7, 'day'))  
(partition p1 values less than (TO_DATE ('2018-02-26', 'YYYY-MM-DD'))) nologging  
tablespace "aasaaa";