What Kind is the Tablespace Locally Managed or Dictionary Managed. If it is
Locally Managed the Next Extent is Used only for Creation and then Ignored.
On 9/20/06, Alessandro Vercelli <alever_at_libero.it> wrote:
>
> The tbs has been created without any storage option and is dedicated to
> the involved partition.
>
> Regards,
>
> Alessandro
>
>
> > What Kind of a TBS is this ???
> >
> > - G
> >
> >
> > On 9/20/06, Alessandro Vercelli <alever_at_libero.it> wrote:
> > >
> > > Hi all,
> > > I needed to change storage parameters for a table partion:
>
> <cut>
>
> > >
> > >
> > > TABLE_NAME PARTITION_NAME INITIAL_EXTENT NEXT_EXTENT
> PCT_INCREASE
> > > -------------- --------------- -------------- -----------
> ------------
> > > TABLE_01 TEST_PART_01
> 104857600 1048576 0
> > >
> > >
> > > Can you help me to understand why NEX_EXTENT did not change?
> > >
>
>
> ------------------------------------------------------
> Tutti i libri che vuoi, li trovi su BOL. Ordini on line e paghi alla
> consegna.
> http://click.libero.it/bol
>
>
>
--
-----------------------------------------------------------
http://iyertalks.blogspot.com/
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Sep 20 2006 - 12:20:38 CDT
