REDEFINITION在线切换普通表到分区表(2)

--创建一个中间表(分区表)
CREATE TABLE big_table2 (
  id            NUMBER(10),
  created_date  DATE,
  lookup_id    NUMBER(10),
  data          VARCHAR2(50)
)
PARTITION BY RANGE (created_date)
(PARTITION big_table_2012 VALUES LESS THAN (TO_DATE('01/01/2013', 'DD/MM/YYYY')) tablespace tbs1,
 PARTITION big_table_2013 VALUES LESS THAN (TO_DATE('01/01/2014', 'DD/MM/YYYY')) tablespace tbs2,
 PARTITION big_table_2014 VALUES LESS THAN (MAXVALUE) tablespace tbs3);