gateway-mnp-dbc/dbcmnpsrc/FE/mnpapp/script/dbUpDate/KitOttobre09/addPartition200910.sql

-- eseguire come utente MNP
spool addPartition_200910.log;

--CREAZIONE NUOVE PARTIZIONI 

-- INIZIO MNP_BIT_OUT_REC
ALTER TABLE MNP_BIT_OUT_REC SPLIT PARTITION MNP_BIT_OUT_REC_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_BIT_OUT_REC15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_BIT_OUT_REC_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_BIT_OUT_REC SPLIT PARTITION MNP_BIT_OUT_REC_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_BIT_OUT_REC16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_BIT_OUT_REC_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_BIT_OUT_REC

-- INIZIO MNP_CCRM_NOTIFICA_OUT
ALTER TABLE MNP_CCRM_NOTIFICA_OUT SPLIT PARTITION MNP_CCRM_NOTIFICA_OUT_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CCRM_NOTIFICA_OUT15 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_CCRM_NOTIFICA_OUT_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_CCRM_NOTIFICA_OUT SPLIT PARTITION MNP_CCRM_NOTIFICA_OUT_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CCRM_NOTIFICA_OUT16 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_CCRM_NOTIFICA_OUT_MAX TABLESPACE TAB_HUGE_2);
-- FINE MNP_CCRM_NOTIFICA_OUT

-- INIZIO MNP_CIRCE_OUT
ALTER TABLE MNP_CIRCE_OUT SPLIT PARTITION MNP_CIRCE_OUT_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CIRCE_OUT15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CIRCE_OUT_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_CIRCE_OUT SPLIT PARTITION MNP_CIRCE_OUT_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CIRCE_OUT16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CIRCE_OUT_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_CIRCE_OUT

-- INIZIO MNP_CIRCE_OUT_REC
ALTER TABLE MNP_CIRCE_OUT_REC SPLIT PARTITION MNP_CIRCE_OUT_REC_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CIRCE_OUT_REC15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CIRCE_OUT_REC_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_CIRCE_OUT_REC SPLIT PARTITION MNP_CIRCE_OUT_REC_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CIRCE_OUT_REC16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CIRCE_OUT_REC_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_CIRCE_OUT_REC

-- INIZIO MNP_CRM_VALIDAZIONE_IN
ALTER TABLE MNP_CRM_VALIDAZIONE_IN SPLIT PARTITION MNP_CRM_VALIDAZIONE_IN_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CRM_VALIDAZIONE_IN15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CRM_VALIDAZIONE_IN_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_CRM_VALIDAZIONE_IN SPLIT PARTITION MNP_CRM_VALIDAZIONE_IN_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CRM_VALIDAZIONE_IN16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CRM_VALIDAZIONE_IN_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_CRM_VALIDAZIONE_IN

-- INIZIO MNP_CRM_VALIDAZIONE_OUT
ALTER TABLE MNP_CRM_VALIDAZIONE_OUT SPLIT PARTITION MNP_CRM_VALIDAZIONE_OUT_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CRM_VALIDAZIONE_OUT15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CRM_VALIDAZIONE_OUT_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_CRM_VALIDAZIONE_OUT SPLIT PARTITION MNP_CRM_VALIDAZIONE_OUT_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CRM_VALIDAZIONE_OUT16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_CRM_VALIDAZIONE_OUT_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_CRM_VALIDAZIONE_OUT

-- INIZIO MNP_GESTIONE_RICHIESTA
ALTER TABLE MNP_GESTIONE_RICHIESTA SPLIT PARTITION MNP_GESTIONE_RICHIESTA_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GESTIONE_RICHIESTA15 TABLESPACE TAB_BIG, PARTITION 
        MNP_GESTIONE_RICHIESTA_MAX TABLESPACE TAB_BIG);
ALTER TABLE MNP_GESTIONE_RICHIESTA SPLIT PARTITION MNP_GESTIONE_RICHIESTA_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GESTIONE_RICHIESTA16 TABLESPACE TAB_BIG, PARTITION 
        MNP_GESTIONE_RICHIESTA_MAX TABLESPACE TAB_BIG);
-- FINE MNP_GESTIONE_RICHIESTA

-- INIZIO MNP_GESTIONE_RICHIESTA_REC
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC SPLIT PARTITION MNP_GESTIONE_RICHIESTA_REC_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GESTIONE_RICHIESTA_REC15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_GESTIONE_RICHIESTA_REC_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC SPLIT PARTITION MNP_GESTIONE_RICHIESTA_REC_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GESTIONE_RICHIESTA_REC16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_GESTIONE_RICHIESTA_REC_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_GESTIONE_RICHIESTA_REC

-- INIZIO MNP_STORICO_PORTING
ALTER TABLE MNP_STORICO_PORTING SPLIT PARTITION MNP_STORICO_PORTING_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_PORTING15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_STORICO_PORTING_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_STORICO_PORTING SPLIT PARTITION MNP_STORICO_PORTING_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_PORTING16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_STORICO_PORTING_MAX TABLESPACE TAB_MEDIUM);

-- FINE MNP_STORICO_PORTING

-- INIZIO MNP_STORICO_RICHIESTA
ALTER TABLE MNP_STORICO_RICHIESTA SPLIT PARTITION MNP_STORICO_RICHIESTA_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICHIESTA15 TABLESPACE TAB_HUGE, PARTITION 
        MNP_STORICO_RICHIESTA_MAX TABLESPACE TAB_HUGE);
ALTER TABLE MNP_STORICO_RICHIESTA SPLIT PARTITION MNP_STORICO_RICHIESTA_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICHIESTA16 TABLESPACE TAB_HUGE, PARTITION 
        MNP_STORICO_RICHIESTA_MAX TABLESPACE TAB_HUGE);
-- FINE MNP_STORICO_RICHIESTA

-- INIZIO MNP_STORICO_RICHIESTA_REC
ALTER TABLE MNP_STORICO_RICHIESTA_REC SPLIT PARTITION MNP_STORICO_RICHIESTA_REC_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICHIESTA_REC15 TABLESPACE TAB_BIG, PARTITION 
        MNP_STORICO_RICHIESTA_REC_MAX TABLESPACE TAB_BIG);
ALTER TABLE MNP_STORICO_RICHIESTA_REC SPLIT PARTITION MNP_STORICO_RICHIESTA_REC_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICHIESTA_REC16 TABLESPACE TAB_BIG, PARTITION 
        MNP_STORICO_RICHIESTA_REC_MAX TABLESPACE TAB_BIG);
-- FINE MNP_STORICO_RICHIESTA_REC

-- INIZIO MNP_XML_IN
ALTER TABLE MNP_XML_IN SPLIT PARTITION MNP_XML_IN_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_IN15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_XML_IN_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_XML_IN SPLIT PARTITION MNP_XML_IN_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_IN16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_XML_IN_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_XML_IN

-- INIZIO MNP_XML_OUT
ALTER TABLE MNP_XML_OUT SPLIT PARTITION MNP_XML_OUT_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_OUT15 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_XML_OUT_MAX TABLESPACE TAB_MEDIUM);
ALTER TABLE MNP_XML_OUT SPLIT PARTITION MNP_XML_OUT_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_OUT16 TABLESPACE TAB_MEDIUM, PARTITION 
        MNP_XML_OUT_MAX TABLESPACE TAB_MEDIUM);
-- FINE MNP_XML_OUT

-- INIZIO MNP_XML_RICHIESTA_IN
ALTER TABLE MNP_XML_RICHIESTA_IN SPLIT PARTITION MNP_XML_RICHIESTA_IN_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_RICHIESTA_IN15 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_XML_RICHIESTA_IN_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_XML_RICHIESTA_IN SPLIT PARTITION MNP_XML_RICHIESTA_IN_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_RICHIESTA_IN16 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_XML_RICHIESTA_IN_MAX TABLESPACE TAB_HUGE_2);
-- FINE MNP_XML_RICHIESTA_IN

-- INIZIO MNP_XML_RICHIESTA_OUT
ALTER TABLE MNP_XML_RICHIESTA_OUT SPLIT PARTITION MNP_XML_RICHIESTA_OUT_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_RICHIESTA_OUT15 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_XML_RICHIESTA_OUT_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_XML_RICHIESTA_OUT SPLIT PARTITION MNP_XML_RICHIESTA_OUT_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_XML_RICHIESTA_OUT16 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_XML_RICHIESTA_OUT_MAX TABLESPACE TAB_HUGE_2);
-- FINE MNP_XML_RICHIESTA_OUT

-- INIZIO MNP_CCRMW_COOP_NOT_OUT
ALTER TABLE MNP_CCRMW_COOP_NOT_OUT SPLIT PARTITION MNP_CCRMW_COOP_NOT_OUT_MAX AT 
        (TO_DATE('2008-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CCRMW_COOP_NOT_OUT12 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_CCRMW_COOP_NOT_OUT_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_CCRMW_COOP_NOT_OUT SPLIT PARTITION MNP_CCRMW_COOP_NOT_OUT_MAX AT 
        (TO_DATE('2009-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CCRMW_COOP_NOT_OUT13 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_CCRMW_COOP_NOT_OUT_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_CCRMW_COOP_NOT_OUT SPLIT PARTITION MNP_CCRMW_COOP_NOT_OUT_MAX AT 
        (TO_DATE('2009-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CCRMW_COOP_NOT_OUT14 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_CCRMW_COOP_NOT_OUT_MAX TABLESPACE TAB_HUGE_2);		
ALTER TABLE MNP_CCRMW_COOP_NOT_OUT SPLIT PARTITION MNP_CCRMW_COOP_NOT_OUT_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CCRMW_COOP_NOT_OUT15 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_CCRMW_COOP_NOT_OUT_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_CCRMW_COOP_NOT_OUT SPLIT PARTITION MNP_CCRMW_COOP_NOT_OUT_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_CCRMW_COOP_NOT_OUT16 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_CCRMW_COOP_NOT_OUT_MAX TABLESPACE TAB_HUGE_2);

-- FINE MNP_CCRMW_COOP_NOT_OUT

-- INIZIO MNP_GEST_RICH_REC_VIRT
ALTER TABLE MNP_GEST_RICH_REC_VIRT SPLIT PARTITION MNP_GEST_RICH_REC_VIRT5_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GEST_RICH_REC_VIRT5 TABLESPACE TAB_HUGE, PARTITION 
        MNP_GEST_RICH_REC_VIRT5_MAX TABLESPACE TAB_HUGE);
ALTER TABLE MNP_GEST_RICH_REC_VIRT SPLIT PARTITION MNP_GEST_RICH_REC_VIRT5_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GEST_RICH_REC_VIRT6 TABLESPACE TAB_HUGE, PARTITION 
        MNP_GEST_RICH_REC_VIRT5_MAX TABLESPACE TAB_HUGE);

-- FINE MNP_GEST_RICH_REC_VIRT

-- INIZIO MNP_STORICO_RICH_REC_VIRT
ALTER TABLE MNP_STORICO_RICH_REC_VIRT SPLIT PARTITION MNP_STORICO_RICH_REC_VIRT5_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICH_REC_VIRT5 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_STORICO_RICH_REC_VIRT5_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_STORICO_RICH_REC_VIRT SPLIT PARTITION MNP_STORICO_RICH_REC_VIRT5_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICH_REC_VIRT6 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_STORICO_RICH_REC_VIRT5_MAX TABLESPACE TAB_HUGE_2);
-- FINE MNP_STORICO_RICH_REC_VIRT

-- INIZIO MNP_GEST_RICH_DONOR_VIRT
ALTER TABLE MNP_GEST_RICH_DONOR_VIRT SPLIT PARTITION MNP_GEST_RICH_DONOR_VIRT5_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GEST_RICH_DONOR_VIRT5 TABLESPACE TAB_HUGE, PARTITION 
        MNP_GEST_RICH_DONOR_VIRT5_MAX TABLESPACE TAB_HUGE);
ALTER TABLE MNP_GEST_RICH_DONOR_VIRT SPLIT PARTITION MNP_GEST_RICH_DONOR_VIRT5_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_GEST_RICH_DONOR_VIRT6 TABLESPACE TAB_HUGE, PARTITION 
        MNP_GEST_RICH_DONOR_VIRT5_MAX TABLESPACE TAB_HUGE);
-- FINE MNP_GEST_RICH_DONOR_VIRT

-- INIZIO MNP_STORICO_RICH_DON_VIRT
ALTER TABLE MNP_STORICO_RICH_DON_VIRT SPLIT PARTITION MNP_STORICO_RICH_DON_VIRT5_MAX AT 
        (TO_DATE('2010-04-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICH_DON_VIRT5 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_STORICO_RICH_DON_VIRT5_MAX TABLESPACE TAB_HUGE_2);
ALTER TABLE MNP_STORICO_RICH_DON_VIRT SPLIT PARTITION MNP_STORICO_RICH_DON_VIRT5_MAX AT 
        (TO_DATE('2010-10-01','YYYY-MM-DD')) INTO ( PARTITION MNP_STORICO_RICH_DON_VIRT6 TABLESPACE TAB_HUGE_2, PARTITION 
        MNP_STORICO_RICH_DON_VIRT5_MAX TABLESPACE TAB_HUGE_2);
-- FINE MNP_STORICO_RICH_DON_VIRT

spool off;