Partition Size Question

From: Dereck L. Dietz <dietzdl_at_ameritech.net>
Date: Wed, 24 Oct 2007 20:20:07 -0400
Message-ID: <QkRTi.753$nN3.281@newssvr17.news.prodigy.net>

This may be obvious but I seem to have a mind block at the moment and would just like to have it confirmed one way or another by people more knowledgeable than I ...

Oracle 10.2.0.1.0, Windows 2003 Server

CREATE INDEX x_vclm_mbr_key

ON v_claim( mbr_key )
LOCAL (

            PARTITION v_clm_2001_0,
            PARTITION v_clm_2002_0,
            PARTITION v_clm_2003_0,
            PARTITION v_clm_2004_0,
            PARTITION v_clm_2005_0,
            PARTITION v_clm_2006_0,
            PARTITION v_clm_2007_0,
            PARTITION v_clm_2008_0,
            PARTITION v_clm_2009_0,
            PARTITION v_clm_2010_0
           )

The index isn't sized. The above is the DDL used to create the index.

Based on the column size and approximately 80,000,000 rows the total size of the index should be about 5,397,760 Kilobytes.

WHAT are the sizes of the partitions? Are each 5,397,760 kilobytes or portions of the total size? Received on Wed Oct 24 2007 - 19:20:07 CDT