alter table tbname split partition ptname at (value) into (partition newpt1 tbs_clause,partition newpt2 tbs_clause);


DFMS.EDIBTO850_DETAIL:

alter table DFMS.EDIBTO850_DETAIL split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.EDIBTO850_DETAIL split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.EDIBTO850_DETAIL split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.EDIBTO850_DETAIL split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);



DFMS.EDIBTO850_PO1PID:

alter table DFMS.EDIBTO850_PO1PID split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.EDIBTO850_PO1PID split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.EDIBTO850_PO1PID split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.EDIBTO850_PO1PID split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);


DFMS.WIP_D_CSN_DETAIL:

alter table DFMS.WIP_D_CSN_DETAIL split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_CSN_DETAIL split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_CSN_DETAIL split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_CSN_DETAIL split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);


DFMS.WIP_D_CSN_MASTER:

alter table DFMS.WIP_D_CSN_MASTER split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_CSN_MASTER split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_CSN_MASTER split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_CSN_MASTER split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);



DFMS.WIP_D_SN_DETAIL:

alter table DFMS.WIP_D_SN_DETAIL split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_SN_DETAIL split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_SN_DETAIL split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_SN_DETAIL split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);


DFMS.WIP_D_SN_INPUT:

alter table DFMS.WIP_D_SN_INPUT split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_SN_INPUT split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_SN_INPUT split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_SN_INPUT split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);


DFMS.WIP_D_STATION_UPH:

alter table DFMS.WIP_D_STATION_UPH split partition PMAX at ('20130701') into (partition P201307 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_STATION_UPH split partition PMAX at ('20140101') into (partition P201401 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_STATION_UPH split partition PMAX at ('20140701') into (partition P201407 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);

alter table DFMS.WIP_D_STATION_UPH split partition PMAX at ('20150101') into (partition P201501 TABLESPACE PART_D_TS2,partition PMAX TABLESPACE PART_D_TS2);


DFMS.WIP_D_WO_DETAIL:

alter table DFMS.WIP_D_WO_DETAIL split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);

alter table DFMS.WIP_D_WO_DETAIL split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);

alter table DFMS.WIP_D_WO_DETAIL split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);

alter table DFMS.WIP_D_WO_DETAIL split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);


DFMS.WIP_L_ASSY_COMPONENT:


alter table DFMS.WIP_L_ASSY_COMPONENT split partition PMAX at (TO_DATE(' 2013-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201307 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);

alter table DFMS.WIP_L_ASSY_COMPONENT split partition PMAX at (TO_DATE(' 2014-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201401 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);

alter table DFMS.WIP_L_ASSY_COMPONENT split partition PMAX at (TO_DATE(' 2014-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201407 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);

alter table DFMS.WIP_L_ASSY_COMPONENT split partition PMAX at (TO_DATE(' 2015-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) into (partition P201501 TABLESPACE PART_D_TS1,partition PMAX TABLESPACE PART_D_TS1);