2 建立Partation Table

https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables007.htm#ADMIN01514

續
原來的  TABLE

CREATE TABLE "MIKE1"."TABLE6"
   ( "SEQ" NUMBER NOT NULL ENABLE,
"DATESTR" DATE NOT NULL ENABLE,
"R" NUMBER DEFAULT 10 NOT NULL ENABLE
   )
  TABLESPACE "TB" ;


改成

CREATE TABLE "MIKE1"."TABLE7"
   ( "SEQ" NUMBER NOT NULL ENABLE,
 "DATESTR" DATE NOT NULL ENABLE,
 "R" NUMBER DEFAULT 10 NOT NULL ENABLE,
CONSTRAINT "TABLE7_PK" PRIMARY KEY ("SEQ")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS 

  TABLESPACE "TB"  ENABLE
   )
  TABLESPACE "TB" 
PARTITION BY RANGE( DATESTR)
(
 PARTITION TABLE7_201801 VALUES LESS THAN(TO_DATE('2018/02/01','YYYY/MM/DD')),
 PARTITION TABLE7_201802 VALUES LESS THAN(TO_DATE('2018/03/01','YYYY/MM/DD')),
 PARTITION TABLE7_201803 VALUES LESS THAN(TO_DATE('2018/04/01','YYYY/MM/DD')),
 PARTITION TABLE7_201804 VALUES LESS THAN(TO_DATE('2018/05/01','YYYY/MM/DD')),
 PARTITION TABLE7_201805 VALUES LESS THAN(TO_DATE('2018/06/01','YYYY/MM/DD')),
 PARTITION TABLE7_201806 VALUES LESS THAN(TO_DATE('2018/07/01','YYYY/MM/DD')),
 PARTITION TABLE7_201807 VALUES LESS THAN(TO_DATE('2018/08/01','YYYY/MM/DD')),
 PARTITION TABLE7_201808 VALUES LESS THAN(TO_DATE('2018/09/01','YYYY/MM/DD')),
 PARTITION TABLE7_201809 VALUES LESS THAN(TO_DATE('2018/10/01','YYYY/MM/DD')),
 PARTITION TABLE7_201810 VALUES LESS THAN(TO_DATE('2018/11/01','YYYY/MM/DD')),
 PARTITION TABLE7_201811 VALUES LESS THAN(TO_DATE('2018/12/01','YYYY/MM/DD')),
 PARTITION TABLE7_201812 VALUES LESS THAN(TO_DATE('2019/01/01','YYYY/MM/DD'))
);





ALTER TABLE MIKE1.TABLE7
  SET INTERVAL ((NUMTOYMINTERVAL(1, 'MONTH')))  ;