› Fóruns › Banco de dados Oracle › Partitioned Table › Partitioned Table
vierivoce terá que exportar a tabela , truncar e importar novamente,
com export, datapump , CTAS, ou da maneira que quiser.
O oracle irá se encarregar de inserir as linhas correspondentes a cada partição.
é bom particionar os índices desta tabela também,
e monitorar as Waits antes e depois da implementação do particionamento.
para averiguar e evidenciar os ganhos.
ex: particionamento por faixa, tabela e index:
anual:
PARTITION “PT_HIST_ESTOQUE_3TRI2007” VALUES LESS THAN (TO_DATE(‘ 2007-10-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PARTITION “PT_HIST_ESTOQUE_4TRI2007” VALUES LESS THAN (TO_DATE(‘ 2008-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
trimestral:
PARTITION “PT_HIST_ESTOQUE_2TRI2009” VALUES LESS THAN (TO_DATE(‘ 2009-07-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PARTITION “PT_HIST_ESTOQUE_3TRI2009” VALUES LESS THAN (TO_DATE(‘ 2009-10-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
ai vc vai adaptando as partições conforme a regra que precisa,
para trabalhar com meses e ano é bem tranquilo.
Mais no oracle existem outros operadores para vc fazer particionamento…. mas este se enquadra perfeitamente a sua necessidade.
CREATE TABLE “DBO_DW”.”TB_HISTORICO_ESTOQUE”
( “DAT_ESTOQUE” DATE NOT NULL ENABLE,
“SK_FILIAL” NUMBER(15,0) NOT NULL ENABLE,
“SK_SKU” NUMBER(15,0) NOT NULL ENABLE,
“QTD_INICIAL” NUMBER(10,0),
“QTD_ENTRADA” NUMBER(10,0),
“QTD_SAIDA” NUMBER(10,0),
“QTD_VENDIDA” NUMBER(10,0),
“QTD_FINAL” NUMBER(10,0),
“DAT_INCLUSAO” DATE NOT NULL ENABLE,
“DAT_ALTERACAO” DATE,
“QTD_TRANSITO” NUMBER(10,0)
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(
BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW”
PARTITION BY RANGE (“DAT_ESTOQUE”)
(PARTITION “PT_HIST_ESTOQUE_1TRI2007” VALUES LESS THAN (TO_DATE(‘ 2007-04-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_2TRI2007” VALUES LESS THAN (TO_DATE(‘ 2007-07-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_3TRI2007” VALUES LESS THAN (TO_DATE(‘ 2007-10-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_4TRI2007” VALUES LESS THAN (TO_DATE(‘ 2008-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_1TRI2008” VALUES LESS THAN (TO_DATE(‘ 2008-04-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_2TRI2008” VALUES LESS THAN (TO_DATE(‘ 2008-07-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_3TRI2008” VALUES LESS THAN (TO_DATE(‘ 2008-10-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_4TRI2008” VALUES LESS THAN (TO_DATE(‘ 2009-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_1TRI2009” VALUES LESS THAN (TO_DATE(‘ 2009-04-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_2TRI2009” VALUES LESS THAN (TO_DATE(‘ 2009-07-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_3TRI2009” VALUES LESS THAN (TO_DATE(‘ 2009-10-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_4TRI2009” VALUES LESS THAN (TO_DATE(‘ 2010-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_1TRI2010” VALUES LESS THAN (TO_DATE(‘ 2010-04-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_2TRI2010” VALUES LESS THAN (TO_DATE(‘ 2010-07-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_3TRI2010” VALUES LESS THAN (TO_DATE(‘ 2010-10-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_4TRI2010” VALUES LESS THAN (TO_DATE(‘ 2011-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_1TRI2011” VALUES LESS THAN (TO_DATE(‘ 2011-04-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_2TRI2011” VALUES LESS THAN (TO_DATE(‘ 2011-07-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_3TRI2011” VALUES LESS THAN (TO_DATE(‘ 2011-10-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS ,
PARTITION “PT_HIST_ESTOQUE_4TRI2011” VALUES LESS THAN (TO_DATE(‘ 2012-01-01 00:00:00’, ‘SYYYY-MM-DD HH24:MI:SS’, ‘NLS_CALENDAR=GREGORIAN’))
PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_DATA_DW” NOCOMPRESS )
PARALLEL 4 ENABLE ROW MOVEMENT ;
CREATE INDEX “DBO_DW”.”IE1_HISTORICO_ESTOQUE_DAT_P_” ON “DBO_DW”.”TB_HISTORICO_ESTOQUE” (“DAT_ESTOQUE”)
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(
BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” LOCAL
(PARTITION “PT_HIST_ESTOQUE_1TRI2007”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_2TRI2007”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_3TRI2007”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_4TRI2007”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_1TRI2008”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_2TRI2008”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_3TRI2008”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_4TRI2008”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_1TRI2009”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_2TRI2009”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_3TRI2009”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_4TRI2009”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_1TRI2010”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_2TRI2010”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_3TRI2010”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_4TRI2010”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_1TRI2011”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_2TRI2011”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_3TRI2011”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ,
PARTITION “PT_HIST_ESTOQUE_4TRI2011”
PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING
STORAGE(INITIAL 81920 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE “TBS_INDX_DW” ) ;