86 lines
11 KiB
SQL
86 lines
11 KiB
SQL
--eseguire come utente MNP
|
|
|
|
spool addPartition.log;
|
|
|
|
ALTER TABLE MNP_BIT_OUT_REC ADD PARTITION MNP_BIT_OUT_REC8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_BIT_OUT_REC ADD PARTITION MNP_BIT_OUT_REC9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_BIT_OUT_REC ADD PARTITION MNP_BIT_OUT_REC10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_BIT_OUT_REC ADD PARTITION MNP_BIT_OUT_REC11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_BIT_OUT_REC ADD PARTITION MNP_BIT_OUT_REC_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CCRM_NOTIFICA_OUT ADD PARTITION MNP_CCRM_NOTIFICA_OUT8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_CCRM_NOTIFICA_OUT ADD PARTITION MNP_CCRM_NOTIFICA_OUT9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_CCRM_NOTIFICA_OUT ADD PARTITION MNP_CCRM_NOTIFICA_OUT10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_CCRM_NOTIFICA_OUT ADD PARTITION MNP_CCRM_NOTIFICA_OUT11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_CCRM_NOTIFICA_OUT ADD PARTITION MNP_CCRM_NOTIFICA_OUT_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_CIRCE_OUT ADD PARTITION MNP_CIRCE_OUT8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT ADD PARTITION MNP_CIRCE_OUT9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT ADD PARTITION MNP_CIRCE_OUT10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT ADD PARTITION MNP_CIRCE_OUT11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT ADD PARTITION MNP_CIRCE_OUT_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT_REC ADD PARTITION MNP_CIRCE_OUT_REC8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT_REC ADD PARTITION MNP_CIRCE_OUT_REC9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT_REC ADD PARTITION MNP_CIRCE_OUT_REC10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT_REC ADD PARTITION MNP_CIRCE_OUT_REC11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CIRCE_OUT_REC ADD PARTITION MNP_CIRCE_OUT_REC_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_IN ADD PARTITION MNP_CRM_VALIDAZIONE_IN8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_IN ADD PARTITION MNP_CRM_VALIDAZIONE_IN9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_IN ADD PARTITION MNP_CRM_VALIDAZIONE_IN10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_IN ADD PARTITION MNP_CRM_VALIDAZIONE_IN11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_IN ADD PARTITION MNP_CRM_VALIDAZIONE_IN_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_OUT ADD PARTITION MNP_CRM_VALIDAZIONE_OUT8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_OUT ADD PARTITION MNP_CRM_VALIDAZIONE_OUT9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_OUT ADD PARTITION MNP_CRM_VALIDAZIONE_OUT10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_OUT ADD PARTITION MNP_CRM_VALIDAZIONE_OUT11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_CRM_VALIDAZIONE_OUT ADD PARTITION MNP_CRM_VALIDAZIONE_OUT_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA ADD PARTITION MNP_GESTIONE_RICHIESTA8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA ADD PARTITION MNP_GESTIONE_RICHIESTA9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA ADD PARTITION MNP_GESTIONE_RICHIESTA10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA ADD PARTITION MNP_GESTIONE_RICHIESTA11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA ADD PARTITION MNP_GESTIONE_RICHIESTA_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC ADD PARTITION MNP_GESTIONE_RICHIESTA_REC8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC ADD PARTITION MNP_GESTIONE_RICHIESTA_REC9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC ADD PARTITION MNP_GESTIONE_RICHIESTA_REC10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC ADD PARTITION MNP_GESTIONE_RICHIESTA_REC11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_GESTIONE_RICHIESTA_REC ADD PARTITION MNP_GESTIONE_RICHIESTA_REC_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_SID_IN ADD PARTITION MNP_SID_IN8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_SID_IN ADD PARTITION MNP_SID_IN9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_SID_IN ADD PARTITION MNP_SID_IN10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_SID_IN ADD PARTITION MNP_SID_IN11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_SID_IN ADD PARTITION MNP_SID_IN_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_STORICO_PORTING ADD PARTITION MNP_STORICO_PORTING8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_STORICO_PORTING ADD PARTITION MNP_STORICO_PORTING9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_STORICO_PORTING ADD PARTITION MNP_STORICO_PORTING10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_STORICO_PORTING ADD PARTITION MNP_STORICO_PORTING11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_STORICO_PORTING ADD PARTITION MNP_STORICO_PORTING_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA ADD PARTITION MNP_STORICO_RICHIESTA8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_HUGE;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA ADD PARTITION MNP_STORICO_RICHIESTA9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_HUGE;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA ADD PARTITION MNP_STORICO_RICHIESTA10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_HUGE;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA ADD PARTITION MNP_STORICO_RICHIESTA11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_HUGE;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA ADD PARTITION MNP_STORICO_RICHIESTA_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_HUGE;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA_REC ADD PARTITION MNP_STORICO_RICHIESTA_REC8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA_REC ADD PARTITION MNP_STORICO_RICHIESTA_REC9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA_REC ADD PARTITION MNP_STORICO_RICHIESTA_REC10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA_REC ADD PARTITION MNP_STORICO_RICHIESTA_REC11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_STORICO_RICHIESTA_REC ADD PARTITION MNP_STORICO_RICHIESTA_REC_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_BIG;
|
|
ALTER TABLE MNP_XML_IN ADD PARTITION MNP_XML_IN8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_IN ADD PARTITION MNP_XML_IN9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_IN ADD PARTITION MNP_XML_IN10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_IN ADD PARTITION MNP_XML_IN11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_IN ADD PARTITION MNP_XML_IN_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_OUT ADD PARTITION MNP_XML_OUT8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_OUT ADD PARTITION MNP_XML_OUT9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_OUT ADD PARTITION MNP_XML_OUT10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_OUT ADD PARTITION MNP_XML_OUT11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_OUT ADD PARTITION MNP_XML_OUT_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_MEDIUM;
|
|
ALTER TABLE MNP_XML_RICHIESTA_IN ADD PARTITION MNP_XML_RICHIESTA_IN8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_IN ADD PARTITION MNP_XML_RICHIESTA_IN9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_IN ADD PARTITION MNP_XML_RICHIESTA_IN10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_IN ADD PARTITION MNP_XML_RICHIESTA_IN11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_IN ADD PARTITION MNP_XML_RICHIESTA_IN_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_OUT ADD PARTITION MNP_XML_RICHIESTA_OUT8 VALUES LESS THAN (TO_DATE('20061001','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_OUT ADD PARTITION MNP_XML_RICHIESTA_OUT9 VALUES LESS THAN (TO_DATE('20070401','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_OUT ADD PARTITION MNP_XML_RICHIESTA_OUT10 VALUES LESS THAN (TO_DATE('20071001','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_OUT ADD PARTITION MNP_XML_RICHIESTA_OUT11 VALUES LESS THAN (TO_DATE('20080401','YYYYMMDD')) TABLESPACE TAB_HUGE_2;
|
|
ALTER TABLE MNP_XML_RICHIESTA_OUT ADD PARTITION MNP_XML_RICHIESTA_OUT_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TAB_HUGE_2;
|
|
|
|
spool off; |