Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Sochaux (France)
    Posts
    55

    Unanswered: Create Materialized views partitionned by range

    Hi all,
    i've got a problem.
    i want to create a materialized view partitionned by range.
    I wrote my code like this :

    Code:
    CREATE MATERIALIZED VIEW DQAVM22(
    PARTITION BY RANGE (DATE_EMON)
    SUBPARTITION BY LIST (CODE_FAMILLE)
    SUBPARTITION TEMPLATE(
     SUBPARTITION SP1 VALUES ('1CA8','1CS8','1PS2','1CA4','1CA6'),
     SUBPARTITION SP2 VALUES ('2CM4','2PM4','2PU5','2CU5','2IU6','2PU6','2CU6','1CM5','2CM5','2PM5','1PM5','2PU3','2CU3'),
     SUBPARTITION SP3 VALUES ('1PT5','1PN5'),
     SUBPARTITION SP4 VALUES ('1CX4','1PD9','1CVD','1PZ8','1PVV','1CVV','1IVV','1EVV','1CU6','1CV8','1EU6','1IU6','1PU6','1CX1','1CX3','1PD2','1PD6','1PD8','1PZ6'),
     SUBPARTITION SP5 VALUES ('1PT1'),
     SUBPARTITION SP6 VALUES ('1C6N','1CN6','1CN7','1CN2','KPT1','KPM4','KCN7','KPD6','KPD9','KPN5','KC2X','VEHI','KCM4','0C2X','1C2X','1CS9','1P25','2CN6','3PD9','3PU3','KC6N','KCN2','KCN6','KCS9','KCVD','KP54','KP55','KPD8','KPJ9','KPR5','KCM5','KPM5'), 
     SUBPARTITION SP7 VALUES (DEFAULT) 
     )
    (
    PARTITION DQAVM22_P01 VALUES LESS THAN (TO_DATE(' 1997-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P01  PCTFREE 2 STORAGE (INITIAL 15M),
    PARTITION DQAVM22_P02 VALUES LESS THAN (TO_DATE(' 1997-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P02  PCTFREE 2 STORAGE (INITIAL 15M),
    PARTITION DQAVM22_P03 VALUES LESS THAN (TO_DATE(' 1998-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P03  PCTFREE 2 STORAGE (INITIAL 29M),
    PARTITION DQAVM22_P04 VALUES LESS THAN (TO_DATE(' 1998-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P04  PCTFREE 2 STORAGE (INITIAL 37M),
    PARTITION DQAVM22_P05 VALUES LESS THAN (TO_DATE(' 1998-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P05  PCTFREE 2 STORAGE (INITIAL 33M),
    PARTITION DQAVM22_P06 VALUES LESS THAN (TO_DATE(' 1998-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P06  PCTFREE 2 STORAGE (INITIAL 52M),
    PARTITION DQAVM22_P07 VALUES LESS THAN (TO_DATE(' 1999-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P07  PCTFREE 2 STORAGE (INITIAL 50M),
    PARTITION DQAVM22_P08 VALUES LESS THAN (TO_DATE(' 1999-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P08  PCTFREE 2 STORAGE (INITIAL 62M),
    PARTITION DQAVM22_P09 VALUES LESS THAN (TO_DATE(' 1999-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P09  PCTFREE 2 STORAGE (INITIAL 57M),
    PARTITION DQAVM22_P10 VALUES LESS THAN (TO_DATE(' 1999-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P10  PCTFREE 2 STORAGE (INITIAL 74M),
    PARTITION DQAVM22_P11 VALUES LESS THAN (TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P11  PCTFREE 2 STORAGE (INITIAL 81M),
    PARTITION DQAVM22_P12 VALUES LESS THAN (TO_DATE(' 2000-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P12  PCTFREE 2 STORAGE (INITIAL 67M),
    PARTITION DQAVM22_P13 VALUES LESS THAN (TO_DATE(' 2000-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P13  PCTFREE 2 STORAGE (INITIAL 65M),
    PARTITION DQAVM22_P14 VALUES LESS THAN (TO_DATE(' 2000-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P14  PCTFREE 2 STORAGE (INITIAL 89M),
    PARTITION DQAVM22_P15 VALUES LESS THAN (TO_DATE(' 2001-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P15  PCTFREE 2 STORAGE (INITIAL 112M),
    PARTITION DQAVM22_P16 VALUES LESS THAN (TO_DATE(' 2001-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P16  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P17 VALUES LESS THAN (TO_DATE(' 2001-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P17  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P18 VALUES LESS THAN (TO_DATE(' 2001-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P18  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P19 VALUES LESS THAN (TO_DATE(' 2002-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P19  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P20 VALUES LESS THAN (TO_DATE(' 2002-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P20  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P21 VALUES LESS THAN (TO_DATE(' 2002-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P21  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P22 VALUES LESS THAN (TO_DATE(' 2002-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P22  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P23 VALUES LESS THAN (TO_DATE(' 2003-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P23  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P24 VALUES LESS THAN (TO_DATE(' 2003-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P24  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P25 VALUES LESS THAN (TO_DATE(' 2003-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P25  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P26 VALUES LESS THAN (TO_DATE(' 2003-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P26  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P27 VALUES LESS THAN (TO_DATE(' 2004-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P27  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P28 VALUES LESS THAN (TO_DATE(' 2004-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P28  PCTFREE 2 STORAGE (INITIAL 130M)
    )
    ENABLE QUERY REWRITE
    AS
    SELECT  DQAQT1B.VIN,
    	DQAQT1B.DATE_EMON,
    	DQAQT1B.ANNEE_EMON,
    	DQAQT1B.TRIMESTRE_EMON,
    	DQAQT1B.MOIS_EMON,
    	DQAQT1B.DATE_ECOM,
    	DQAQT1B.ANNEE_ECOM,
    	DQAQT1B.TRIMESTRE_ECOM,
    	DQAQT1B.MOIS_ECOM,
    	DQAQT1B.TITRE_24,
    	DQAQT1B.TITRE_10,
    	DQAQT1B.CODE_FAMILLE,
    	DQAQT1B.CODE_CENTRE_PRODUCTION,
    	DQAQT1B.DATE_ENTREE_GARANTIE,
    	DQAQT1B.ANNEE_ENTREE_GARANTIE,
    	DQAQT1B.TRIMESTRE_ENTREE_GARANTIE,
    	DQAQT1B.MOIS_ENTREE_GARANTIE,
    	DQAQT1B.CODE_POINT_VENTE,
    	DQAQT1B.CODE_PAYS_POINT_VENTE,
    	DQAQT22.NO_DOSSIER_DDE_CREDIT,
    	DQAQT22.DATE_INTERVENTION,
    	DQAQT22.CODE_CAUSE,
    	DQAQT22.CODE_IMPUTATION_GARANTIE,
    	DQAQT22.CODE_DEFAUT_GARANTIE,
    	DQAQT22.CODE_PRESTATAIRE_INTERVENTION,
    	DQAQT22.INDICATEUR_TYPE_DEMANDE,
    	DQAQT22.INDICATEUR_VALORISATION,
    	DQAQT22.INDICATEUR_ECHANGE_PIECE,
    	DQAQT22.NO_DOSSIER_INCIDENT,
    	DQAQT22.KILOMETRAGE_VEHICULE,
    	DQAQT22.NB_MOIS_ROULAGE_INTERVENTION,
    	DQAQT22.COUT_TOTAL,
    	DQAQT22.NB_DDE_CREDIT
    FROM    DQAQT1B,
    	DQAQT22
    WHERE   DQAQT1B.VIN = DQAQT22.VIN)
    ;
    When i run it under sqlplus, i've got this error :
    Code:
    PARTITION BY RANGE (DATE_EMON)
    *
    ERREUR a la ligne 2 :
    ORA-00905: Mot-cle absent
    I think that i put my PARTITION keyword at a wrong place.
    Can you help me...

  2. #2
    Join Date
    Jul 2003
    Posts
    2,296
    put all the partitioning stuff at the end.

    Code:
    CREATE MATERIALIZED VIEW DQAVM22
    ENABLE QUERY REWRITE
    AS
    SELECT  DQAQT1B.VIN,
    	DQAQT1B.DATE_EMON,
    	DQAQT1B.ANNEE_EMON,
    	DQAQT1B.TRIMESTRE_EMON,
    	DQAQT1B.MOIS_EMON,
    	DQAQT1B.DATE_ECOM,
    	DQAQT1B.ANNEE_ECOM,
    	DQAQT1B.TRIMESTRE_ECOM,
    	DQAQT1B.MOIS_ECOM,
    	DQAQT1B.TITRE_24,
    	DQAQT1B.TITRE_10,
    	DQAQT1B.CODE_FAMILLE,
    	DQAQT1B.CODE_CENTRE_PRODUCTION,
    	DQAQT1B.DATE_ENTREE_GARANTIE,
    	DQAQT1B.ANNEE_ENTREE_GARANTIE,
    	DQAQT1B.TRIMESTRE_ENTREE_GARANTIE,
    	DQAQT1B.MOIS_ENTREE_GARANTIE,
    	DQAQT1B.CODE_POINT_VENTE,
    	DQAQT1B.CODE_PAYS_POINT_VENTE,
    	DQAQT22.NO_DOSSIER_DDE_CREDIT,
    	DQAQT22.DATE_INTERVENTION,
    	DQAQT22.CODE_CAUSE,
    	DQAQT22.CODE_IMPUTATION_GARANTIE,
    	DQAQT22.CODE_DEFAUT_GARANTIE,
    	DQAQT22.CODE_PRESTATAIRE_INTERVENTION,
    	DQAQT22.INDICATEUR_TYPE_DEMANDE,
    	DQAQT22.INDICATEUR_VALORISATION,
    	DQAQT22.INDICATEUR_ECHANGE_PIECE,
    	DQAQT22.NO_DOSSIER_INCIDENT,
    	DQAQT22.KILOMETRAGE_VEHICULE,
    	DQAQT22.NB_MOIS_ROULAGE_INTERVENTION,
    	DQAQT22.COUT_TOTAL,
    	DQAQT22.NB_DDE_CREDIT
    FROM    DQAQT1B,
    	DQAQT22
    WHERE   DQAQT1B.VIN = DQAQT22.VIN
    PARTITION BY RANGE (DATE_EMON)
    SUBPARTITION BY LIST (CODE_FAMILLE)
    SUBPARTITION TEMPLATE(
    SUBPARTITION SP1 VALUES ('1CA8','1CS8','1PS2','1CA4','1CA6'),
    SUBPARTITION SP2 VALUES
    ('2CM4', '2PM4', '2PU5', '2CU5', '2IU6', '2PU6', '2CU6', '1CM5','2CM5',
    '2PM5','1PM5','2PU3','2CU3'),
    SUBPARTITION SP3 VALUES ('1PT5','1PN5'),
    SUBPARTITION SP4 VALUES  ('1CX4','1PD9','1CVD','1PZ8','1PVV','1CVV',
    '1IVV','1EVV','1CU6','1CV8','1EU6','1IU6','1PU6',
    '1CX1','1CX3','1PD2','1PD6','1PD8','1PZ6'),
    SUBPARTITION SP5 VALUES ('1PT1'),
    SUBPARTITION SP6 VALUES
    ('1C6N','1CN6','1CN7','1CN2','KPT1','KPM4','KCN7','KPD6','KPD9','KPN5','KC2X','VEHI','KCM4','0C2X','1C2X',
    '1CS9','1P25','2CN6','3PD9','3PU3','KC6N','KCN2','KCN6','KCS9',
    'KCVD','KP54','KP55','KPD8','KPJ9','KPR5','KCM5','KPM5'), 
    SUBPARTITION SP7 VALUES (DEFAULT) 
    (
    PARTITION DQAVM22_P01 VALUES LESS THAN (TO_DATE(' 1997-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P01  PCTFREE 2 STORAGE (INITIAL 15M),
    PARTITION DQAVM22_P02 VALUES LESS THAN (TO_DATE(' 1997-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P02  PCTFREE 2 STORAGE (INITIAL 15M),
    PARTITION DQAVM22_P03 VALUES LESS THAN (TO_DATE(' 1998-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P03  PCTFREE 2 STORAGE (INITIAL 29M),
    PARTITION DQAVM22_P04 VALUES LESS THAN (TO_DATE(' 1998-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P04  PCTFREE 2 STORAGE (INITIAL 37M),
    PARTITION DQAVM22_P05 VALUES LESS THAN (TO_DATE(' 1998-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P05  PCTFREE 2 STORAGE (INITIAL 33M),
    PARTITION DQAVM22_P06 VALUES LESS THAN (TO_DATE(' 1998-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P06  PCTFREE 2 STORAGE (INITIAL 52M),
    PARTITION DQAVM22_P07 VALUES LESS THAN (TO_DATE(' 1999-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P07  PCTFREE 2 STORAGE (INITIAL 50M),
    PARTITION DQAVM22_P08 VALUES LESS THAN (TO_DATE(' 1999-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P08  PCTFREE 2 STORAGE (INITIAL 62M),
    PARTITION DQAVM22_P09 VALUES LESS THAN (TO_DATE(' 1999-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P09  PCTFREE 2 STORAGE (INITIAL 57M),
    PARTITION DQAVM22_P10 VALUES LESS THAN (TO_DATE(' 1999-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P10  PCTFREE 2 STORAGE (INITIAL 74M),
    PARTITION DQAVM22_P11 VALUES LESS THAN (TO_DATE(' 2000-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P11  PCTFREE 2 STORAGE (INITIAL 81M),
    PARTITION DQAVM22_P12 VALUES LESS THAN (TO_DATE(' 2000-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P12  PCTFREE 2 STORAGE (INITIAL 67M),
    PARTITION DQAVM22_P13 VALUES LESS THAN (TO_DATE(' 2000-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P13  PCTFREE 2 STORAGE (INITIAL 65M),
    PARTITION DQAVM22_P14 VALUES LESS THAN (TO_DATE(' 2000-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P14  PCTFREE 2 STORAGE (INITIAL 89M),
    PARTITION DQAVM22_P15 VALUES LESS THAN (TO_DATE(' 2001-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P15  PCTFREE 2 STORAGE (INITIAL 112M),
    PARTITION DQAVM22_P16 VALUES LESS THAN (TO_DATE(' 2001-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P16  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P17 VALUES LESS THAN (TO_DATE(' 2001-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P17  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P18 VALUES LESS THAN (TO_DATE(' 2001-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P18  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P19 VALUES LESS THAN (TO_DATE(' 2002-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P19  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P20 VALUES LESS THAN (TO_DATE(' 2002-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P20  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P21 VALUES LESS THAN (TO_DATE(' 2002-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P21  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P22 VALUES LESS THAN (TO_DATE(' 2002-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P22  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P23 VALUES LESS THAN (TO_DATE(' 2003-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P23  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P24 VALUES LESS THAN (TO_DATE(' 2003-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P24  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P25 VALUES LESS THAN (TO_DATE(' 2003-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P25  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P26 VALUES LESS THAN (TO_DATE(' 2003-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P26  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P27 VALUES LESS THAN (TO_DATE(' 2004-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P27  PCTFREE 2 STORAGE (INITIAL 130M),
    PARTITION DQAVM22_P28 VALUES LESS THAN (TO_DATE(' 2004-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) TABLESPACE TBS_DQAVM22_P28  PCTFREE 2 STORAGE (INITIAL 130M)
    )
    ;
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •