Re: Table partion storage

  • From: "Ganesh Raja" <ganesh.raja@xxxxxxxxx>
  • To: "Alessandro Vercelli" <alever@xxxxxxxxx>
  • Date: Wed, 20 Sep 2006 19:20:38 +0200

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.

- Ganesh


On 9/20/06, Alessandro Vercelli <alever@xxxxxxxxx> 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@xxxxxxxxx> 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/

Other related posts: