Re: defrag needed

Konstantinos Agouros wrote:
>
> In <c18ea449.0108200115.5e075ee_at_posting.google.com> crsoza_at_hotmail.com (C. R. Soza) writes:
>
> >The easiest way to avoid defrag is to size the tablespace with equi
> >extents and create table which inherits these storage attributes.
> What are equi-extends? Sorry if this question is stupid.
>
> Konstantin
> --
> Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_agouros.de
> Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
> ----------------------------------------------------------------------------
> "Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres

THis is where (per tablespace) all extents are sized the same. By definition you will not have a fragmenation problem since every segment will be able to fit into any free space chunk in the tablespace

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."