快速迁移物化视图分区策略

创建目标表（先增加我们需要扩容的分区）
CREATE TABLE FP_SFD_TEST
   (  "ID" NUMBER(12,0) NOT NULL ENABLE, 
  "SFBZ" VARCHAR2(1) NOT NULL ENABLE, 
  "SFRQ" DATE NOT NULL ENABLE, 
  "SWJG_DM" VARCHAR2(11) NOT NULL ENABLE, 
  "FP_ZL" VARCHAR2(2) DEFAULT 'YB', 
  "FP_DM" VARCHAR2(12) NOT NULL ENABLE, 
  "SFLB" VARCHAR2(3) NOT NULL ENABLE, 
  "SPDW_DM" VARCHAR2(80), 
  "NSRSBH" VARCHAR2(20), 
  "GPR" VARCHAR2(30), 
  "FP_QS_HM" NUMBER(8,0), 
  "FP_SL" NUMBER(8,0), 
  "RK_DJ" NUMBER(8,4), 
  "FP_JE" NUMBER(16,4), 
  "CZY_MC" VARCHAR2(30), 
  "BJ" VARCHAR2(40), 
  "OLDFLAG" VARCHAR2(1), 
  "FP_LB" VARCHAR2(2) DEFAULT 'YB', 
  "NSR_XZ" NUMBER, 
   CONSTRAINT "PK_FP_SFD_TEST" PRIMARY KEY ("ID")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 
  STORAGE(INITIAL 4194304 NEXT 4194304 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "INDX"  ENABLE
   ) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(
  BUFFER_POOL DEFAULT)
  TABLESPACE "HTJS" 

  PARTITION BY RANGE ("SFRQ") 
 (PARTITION "P_FP_SFD_2011"  VALUES LESS THAN (TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TBS_DAT_PAR_07" NOCOMPRESS , 
 PARTITION "P_FP_SFD_2012"  VALUES LESS THAN (TO_DATE(' 2013-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TBS_DAT_PAR_08" NOCOMPRESS , 
 PARTITION "P_FP_SFD_2013"  VALUES LESS THAN (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TBS_DAT_PAR_09" NOCOMPRESS , 
 PARTITION "P_FP_SFD_2014"  VALUES LESS THAN (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TBS_DAT_PAR_10" NOCOMPRESS , 
 PARTITION "P_FP_SFD_2015"  VALUES LESS THAN (TO_DATE(' 2016-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "TBS_DAT_PAR_10" NOCOMPRESS , 
 PARTITION "P_FP_SFD_MAX"  VALUES LESS THAN (MAXVALUE) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)