添加分区表的分区和子分区的命令模板

 

 

ALTER TABLE NMAGENT.TF_B_MPHONEINFO_AGENT
 ADD
  PARTITION TF_B_MPHONEINFO_AGENT200809 VALUES LESS THAN ('200810')
    LOGGING
    TABLESPACE TBS_INTERFACE
    PCTFREE    10
    INITRANS   1
    MAXTRANS   255
  ( SUBPARTITION TF_B_MPHONEINFO_200809_9001 VALUES ('9001')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9002 VALUES ('9002')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9003 VALUES ('9003')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9004 VALUES ('9004')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9005 VALUES ('9005')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9006 VALUES ('9006')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9007 VALUES ('9007')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9008 VALUES ('9008')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9009 VALUES ('9009')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9010 VALUES ('9010')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9011 VALUES ('9011')    TABLESPACE TBS_INTERFACE,
    SUBPARTITION TF_B_MPHONEINFO_200809_9012 VALUES ('9012')    TABLESPACE TBS_INTERFACE );