可不可以这样写:
partition by range (hiredate)
(partition p01 values less than(to_date('02','mm')) tablespace ptbs01,
partition p02 values less than(to_date('03','mm')) tablespace ptbs02,
partition p03 values less than(to_date('04','mm')) tablespace ptbs03,
partition p04 values less than(to_date('05','mm')) tablespace ptbs04,
partition p05 values less than(to_date('06','mm')) tablespace ptbs05,
partition p06 values less than(to_date('07','mm')) tablespace ptbs06,
partition p07 values less than(to_date('08','mm')) tablespace ptbs07,
partition p08 values less than(to_date('09','mm')) tablespace ptbs08,
partition p09 values less than(to_date('10','mm')) tablespace ptbs09,
partition p10 values less than(to_date('11','mm')) tablespace ptbs10,
partition p11 values less than(to_date('12','mm')) tablespace ptbs11,
partition p12 values less than(to_date('12','mm')+31) tablespace ptbs12 ) ;