深入Oracle 11g分区功能

复制SQL>CREATETABLE SALES_PART (TIME_ID NUMBER,深入 REGION_ID NUMBER, ORDER_ID NUMBER, ORDER_DATE DATE, SALES_QTY NUMBER(10,2), SALES_AMOUNT NUMBER(12,2) ) PARTITION BY RANGE (ORDER_DATE) INTERVAL (NUMTOYMINTERVAL(1,month) (PARTITION p_first VALUES LESS THAN (01-JAN-2006); 1.2.3.4.5.6.7.8.9.10.11.