"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<ncZFa.196$Ab2.5264_at_newsfeeds.bigpond.com>...
> "cc" <dinos5_at_yahoo.com> wrote in message
> news:7c675a3b.0306120102.758158e7_at_posting.google.com...
> > Hi all,
> >
> > I am trying to truncate a partiton which has 4 extents. After issuing
> > alter table... truncate partition ... drop storage statement I see
> > again 4 extents for this partition in user_extents ...
> >
> > parition's minextent value = 1
> >
> > any idea?
> >
> > thanks in advance.
>
> Hi CC,
>
> Any chance you're using a locally managed tablespace ?
>
> Any chance that the partition has an *initial extent* size equivalent to the
> sum(rounded up) of the 4 uniform (or 64K auto allocated) extents ?
>
> In which case, what you're seeing is expect behaviour as drop storage only
> drops storage up to the minextents of the segment.
>
> So look up the initial size and see what is tells you.
>
> Good Luck
>
> Richard
yes I use LM TBS...
every extent = uniform size
Received on Fri Jun 13 2003 - 02:41:07 CDT
