摘要:
CREATE TABLE AAA( ID NUMBER(20), NAME VARCHAR2(128), RTIME DATE)PARTITION BY RANGE (RTIME)--INTERVAL(NUMTOYMINTERVAL(1,'MONTH'))INTERVAL(NUMTODSINTERVAL(1, 'DAY'))( PARTITION PAAA VALUES LESS THAN (to_date('2013-05-28','yyyy-mm-dd')) ); 阅读全文