[ОТВЕТИТЬ]
Опции темы
09.02.2012 15:22  
Mr_Vito
табличку ffmaprep_ разбил на партиции по аналогии с ffmaprep
у ней есть партиции и субпартиции
табличку нужно сжать
только не понял я как это сделать, в какой последовательности, подскажите?
вот табличка:
Код:
-- Start of DDL Script for Table SUPERMAG.FFMAPREP_
-- Generated 09-ôåâ-2012 14:35:30 from SUPERMAG@ILISHCO

CREATE TABLE ffmaprep_
    (rectype                        NUMBER(10,0) NOT NULL,
    article                        VARCHAR2(50 BYTE) NOT NULL,
    saletype                       CHAR(2 BYTE) NOT NULL,
    saleid                         VARCHAR2(50 BYTE) NOT NULL,
    salespecitem                   NUMBER(10,0) NOT NULL,
    salelocationfrom               NUMBER(10,0),
    salelocationto                 NUMBER(10,0),
    saledate                       DATE NOT NULL,
    saleop                         NUMBER(5,0) NOT NULL,
    saleuserop                     NUMBER(5,0),
    salepaycash                    CHAR(1 BYTE) NOT NULL,
    saleclientindex                NUMBER(10,0),
    saleq                          NUMBER(14,3) NOT NULL,
    salesum                        NUMBER(19,4) NOT NULL,
    salenovat                      NUMBER(19,4) NOT NULL,
    salenotax                      NUMBER(19,4) NOT NULL,
    salecurtype                    NUMBER(5,0) NOT NULL,
    salesumcur                     NUMBER(19,4) NOT NULL,
    salevatrate                    NUMBER(8,4) NOT NULL,
    primecost                      NUMBER(19,4) NOT NULL,
    primecostnovat                 NUMBER(19,4) NOT NULL,
    primecostforced                CHAR(1 BYTE) NOT NULL,
    forcedmapping                  CHAR(1 BYTE),
    quantity                       NUMBER(14,3) NOT NULL,
    incomeid                       VARCHAR2(50 BYTE),
    incometype                     CHAR(2 BYTE),
    incomespecitem                 NUMBER(10,0),
    incomeclientindex              NUMBER(10,0),
    goodsowner                     NUMBER(5,0),
    incomeq                        NUMBER(14,3),
    incomesum                      NUMBER(19,4),
    incomenovat                    NUMBER(19,4),
    incomevatrate                  NUMBER(8,4),
    incomecurtype                  NUMBER(5,0),
    incomesumcur                   NUMBER(19,4),
    incomedate                     DATE)
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  TABLESPACE  users
  STORAGE   (
    BUFFER_POOL DEFAULT
  )
  NOCACHE
  MONITORING
  PARTITION BY RANGE (SALEDATE)
  SUBPARTITION BY LIST (SALETYPE)
  (
  PARTITION ff4_2009 VALUES LESS THAN (TO_DATE(' 2010-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF4_2009_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF4_2009_WO VALUES('WO')  TABLESPACE fftab
  ),
  PARTITION ff1_2010 VALUES LESS THAN (TO_DATE(' 2010-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF1_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF1_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF1_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF1_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF1_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF1_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF1_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF1_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff2_2010 VALUES LESS THAN (TO_DATE(' 2010-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF2_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF2_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF2_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF2_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF2_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF2_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF2_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF2_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff3_2010 VALUES LESS THAN (TO_DATE(' 2010-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF3_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF3_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF3_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF3_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF3_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF3_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF3_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF3_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff4_2010 VALUES LESS THAN (TO_DATE(' 2010-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF4_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF4_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF4_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF4_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF4_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF4_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF4_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF4_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff5_2010 VALUES LESS THAN (TO_DATE(' 2010-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF5_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF5_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF5_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF5_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF5_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF5_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF5_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF5_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff6_2010 VALUES LESS THAN (TO_DATE(' 2010-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF6_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF6_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF6_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF6_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF6_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF6_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF6_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF6_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff7_2010 VALUES LESS THAN (TO_DATE(' 2010-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF7_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF7_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF7_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF7_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF7_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF7_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF7_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF7_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff8_2010 VALUES LESS THAN (TO_DATE(' 2010-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF8_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF8_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF8_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF8_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF8_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF8_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF8_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF8_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff9_2010 VALUES LESS THAN (TO_DATE(' 2010-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF9_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF9_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF9_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF9_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF9_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF9_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF9_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF9_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff10_2010 VALUES LESS THAN (TO_DATE(' 2010-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF10_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF10_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF10_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF10_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF10_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF10_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF10_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF10_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff11_2010 VALUES LESS THAN (TO_DATE(' 2010-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF11_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF11_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF11_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF11_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF11_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF11_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF11_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF11_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff12_2010 VALUES LESS THAN (TO_DATE(' 2011-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF12_2010_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF12_2010_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF12_2010_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF12_2010_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF12_2010_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF12_2010_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF12_2010_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF12_2010_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff1_2011 VALUES LESS THAN (TO_DATE(' 2011-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF1_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF1_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF1_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF1_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF1_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF1_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF1_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF1_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff2_2011 VALUES LESS THAN (TO_DATE(' 2011-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF2_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF2_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF2_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF2_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF2_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF2_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF2_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF2_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff3_2011 VALUES LESS THAN (TO_DATE(' 2011-04-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF3_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF3_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF3_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF3_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF3_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF3_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF3_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF3_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff4_2011 VALUES LESS THAN (TO_DATE(' 2011-05-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF4_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF4_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF4_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF4_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF4_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF4_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF4_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF4_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff5_2011 VALUES LESS THAN (TO_DATE(' 2011-06-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF5_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF5_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF5_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF5_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF5_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF5_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF5_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF5_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff6_2011 VALUES LESS THAN (TO_DATE(' 2011-07-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF6_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF6_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF6_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF6_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF6_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF6_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF6_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF6_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff7_2011 VALUES LESS THAN (TO_DATE(' 2011-08-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF7_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF7_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF7_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF7_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF7_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF7_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF7_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF7_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff8_2011 VALUES LESS THAN (TO_DATE(' 2011-09-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF8_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF8_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF8_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF8_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF8_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF8_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF8_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF8_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff9_2011 VALUES LESS THAN (TO_DATE(' 2011-10-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF9_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF9_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF9_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF9_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF9_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF9_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF9_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF9_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff10_2011 VALUES LESS THAN (TO_DATE(' 2011-11-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF10_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF10_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF10_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF10_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF10_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF10_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF10_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF10_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff11_2011 VALUES LESS THAN (TO_DATE(' 2011-12-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF11_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF11_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF11_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF11_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF11_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF11_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF11_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF11_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff12_2011 VALUES LESS THAN (TO_DATE(' 2012-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF12_2011_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF12_2011_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF12_2011_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF12_2011_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF12_2011_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF12_2011_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF12_2011_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF12_2011_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff1_2012 VALUES LESS THAN (TO_DATE(' 2012-02-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF1_2012_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF1_2012_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF1_2012_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF1_2012_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF1_2012_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF1_2012_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF1_2012_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF1_2012_PN VALUES('PN')  TABLESPACE fftab
  ),
  PARTITION ff2_2012 VALUES LESS THAN (TO_DATE(' 2012-03-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
  PCTFREE     10
  INITRANS    1
  MAXTRANS    255
  LOGGING
  (
  SUBPARTITION FF2_2012_WI VALUES('WI')  TABLESPACE fftab,
  SUBPARTITION FF2_2012_WO VALUES('WO')  TABLESPACE fftab,
  SUBPARTITION FF2_2012_CS VALUES('CS')  TABLESPACE fftab,
  SUBPARTITION FF2_2012_CR VALUES('CR')  TABLESPACE fftab,
  SUBPARTITION FF2_2012_IW VALUES('IW')  TABLESPACE fftab,
  SUBPARTITION FF2_2012_PE VALUES('PE')  TABLESPACE fftab,
  SUBPARTITION FF2_2012_PO VALUES('PO')  TABLESPACE fftab,
  SUBPARTITION FF2_2012_PN VALUES('PN')  TABLESPACE fftab
  )
  )
  NOPARALLEL
/

-- Grants for Table
GRANT INSERT ON ffmaprep_ TO supermag_fn_repadmin_calc
/
GRANT SELECT ON ffmaprep_ TO supermag_fn_repadmin_calc
/
GRANT UPDATE ON ffmaprep_ TO supermag_fn_repadmin_calc
/




-- Indexes for FFMAPREP_

CREATE INDEX ffmaprep__doc ON ffmaprep_
  (
    saletype                        ASC,
    saleid                          ASC,
    salespecitem                    ASC
  )
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  ffidx
  STORAGE   (
    INITIAL     1073741824
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
NOPARALLEL
NOLOGGING
/

CREATE BITMAP INDEX ffmaprep__locfrom ON ffmaprep_
  (
    salelocationfrom                ASC,
    saledate                        ASC
  )
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  TABLESPACE  indx
  STORAGE   (
    INITIAL     5005312
    MINEXTENTS  1
    MAXEXTENTS  2147483645
    BUFFER_POOL DEFAULT
  )
NOPARALLEL
  LOCAL (
  PARTITION FF4_2009
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2009_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2009_WO TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PN TABLESPACE ffidx
  )
  LOGGING
  )
/

CREATE BITMAP INDEX ffmaprep__locto ON ffmaprep_
  (
    salelocationto                  ASC,
    saledate                        ASC
  )
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  TABLESPACE  indx
  STORAGE   (
    INITIAL     5005312
    MINEXTENTS  1
    MAXEXTENTS  2147483645
    BUFFER_POOL DEFAULT
  )
NOPARALLEL
  LOCAL (
  PARTITION FF4_2009
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2009_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2009_WO TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PN TABLESPACE ffidx
  )
  LOGGING
  )
/

CREATE BITMAP INDEX ffmaprep__saledate ON ffmaprep_
  (
    saledate                        ASC
  )
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  TABLESPACE  indx
  STORAGE   (
    INITIAL     5005312
    MINEXTENTS  1
    MAXEXTENTS  2147483645
    BUFFER_POOL DEFAULT
  )
NOPARALLEL
  LOCAL (
  PARTITION FF4_2009
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2009_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2009_WO TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PN TABLESPACE ffidx
  )
  LOGGING
  )
/

CREATE BITMAP INDEX ffmaprep__supplier ON ffmaprep_
  (
    incomeclientindex               ASC
  )
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  TABLESPACE  indx
  STORAGE   (
    INITIAL     5005312
    MINEXTENTS  1
    MAXEXTENTS  2147483645
    BUFFER_POOL DEFAULT
  )
NOPARALLEL
  LOCAL (
  PARTITION FF4_2009
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2009_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2009_WO TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2010
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2010_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2010_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2010_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2010_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2010_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF3_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF3_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF3_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF3_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF3_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF3_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF4_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF4_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF4_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF4_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF4_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF4_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF5_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF5_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF5_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF5_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF5_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF5_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF6_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF6_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF6_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF6_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF6_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF6_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF7_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF7_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF7_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF7_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF7_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF7_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF8_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF8_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF8_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF8_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF8_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF8_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF9_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF9_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF9_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF9_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF9_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF9_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF10_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF10_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF10_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF10_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF10_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF10_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF11_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF11_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF11_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF11_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF11_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF11_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF12_2011
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF12_2011_WI TABLESPACE ffidx,
  SUBPARTITION FF12_2011_WO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CS TABLESPACE ffidx,
  SUBPARTITION FF12_2011_CR TABLESPACE ffidx,
  SUBPARTITION FF12_2011_IW TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PE TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PO TABLESPACE ffidx,
  SUBPARTITION FF12_2011_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF1_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF1_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF1_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF1_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF1_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF1_2012_PN TABLESPACE ffidx
  )
  LOGGING,
  PARTITION FF2_2012
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  (
  SUBPARTITION FF2_2012_WI TABLESPACE ffidx,
  SUBPARTITION FF2_2012_WO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CS TABLESPACE ffidx,
  SUBPARTITION FF2_2012_CR TABLESPACE ffidx,
  SUBPARTITION FF2_2012_IW TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PE TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PO TABLESPACE ffidx,
  SUBPARTITION FF2_2012_PN TABLESPACE ffidx
  )
  LOGGING
  )
/

CREATE INDEX quest_sx_idx_ ON ffmaprep_
  (
    saleop                          ASC
  )
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  users
  STORAGE   (
    INITIAL     1013972992
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
NOPARALLEL
NOLOGGING
/

CREATE INDEX quest_sx_idx21 ON ffmaprep_
  (
    rectype                         ASC
  )
  PCTFREE     10
  INITRANS    2
  MAXTRANS    255
  TABLESPACE  users
  STORAGE   (
    INITIAL     1017118720
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
NOPARALLEL
NOLOGGING
/

CREATE INDEX ffmaprep__article ON ffmaprep_
  (
    article                         ASC
  )
  PCTFREE     5
  INITRANS    10
  MAXTRANS    255
  TABLESPACE  ffidx
  STORAGE   (
    INITIAL     1073741824
    MINEXTENTS  1
    MAXEXTENTS  2147483645
  )
NOPARALLEL
NOLOGGING
/



-- End of DDL Script for Table SUPERMAG.FFMAPREP_
пробовал:
ALTER TABLE FFMAPREP_ MOVE PARTITION FF4_2009 COMPRESS;
ругается, говорит это только для диапазонных и хэш секций
 
17.02.2012 14:06  
leonid
alter table prob1 modify default attributes for partition t_2009 tablespace users compress;

Добавлено через 2 минуты 46 секунд
Код:
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 
Connected as leonid
 
SQL> drop table prob1;
 
Table dropped
 
SQL> 
SQL> -- Create table
SQL> create table PROB1
  2  (
  3    SALETYPE CHAR(2),
  4    SALEDATE DATE
  5  )
  6  partition by range (SALEDATE)
  7  subpartition by list (SALETYPE)
  8  (
  9    partition T_2009 values less than (TO_DATE(' 2010-01-01 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN'))
 10      tablespace USERS
 11      pctfree 0
 12      initrans 1
 13      maxtrans 255
 14    (
 15      subpartition T_2009_WI values ('WI') tablespace USERS
 16    )
 17  );
 
Table created
 
SQL> 
SQL> select t table_name, t partition_name, t compression
  2  from dba_tab_partitions t
  3  where t table_name like 'PROB1';
 
TABLE_NAME                     PARTITION_NAME                 COMPRESSION
------------------------------ ------------------------------ -----------
PROB1                          T_2009                         NONE
 
SQL> alter table prob1 modify default attributes for partition t_2009 tablespace users compress;
 
Table altered
 
SQL> 
SQL> select t table_name, t partition_name, t compression
  2  from dba_tab_partitions t
  3  where t table_name like 'PROB1';
 
TABLE_NAME                     PARTITION_NAME                 COMPRESSION
------------------------------ ------------------------------ -----------
PROB1                          T_2009                         ENABLED
 
SQL>
В запросе
select t table_name, t partition_name, t compression ...
надо поставить точки, у меня с точками на форум не пропускает.
 
17.02.2012 14:19  
Mtirt
В тэге тоже точки не пропускает?
 
17.02.2012 14:23  
leonid
Цитата:
Сообщение от Mtirt
В тэге тоже точки не пропускает?
Неа, создал тему в Вопросах форума.
 
 
Опции темы



Часовой пояс GMT +3, время: 17:09.

Все в прочитанное - Календарь - RSS - - Карта - Вверх 👫 Яндекс.Метрика
Форум сделан на основе vBulletin®
Copyright ©2000 - 2016, Jelsoft Enterprises Ltd. Перевод: zCarot и OlegON
В случае заимствования информации гипертекстовая индексируемая ссылка на Форум обязательна.