先来几个参考地址：

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";