Re: avoiding tablespace fragmentation

On 6 Jun 2004 05:26:14 -0700, yls177_at_hotmail.com (yls177) wrote:

>is it true that as long as i dont drop/truncate tables, then there
>will be no tablespace fragmentation provided that i set my storage
>parameters at tablespace level as the below
>
>1) initial extent=next extent
>2) pctincrease 0
>
>thanks

1. RTFM everything about Locally Managed Tablespaces
2. check this newsgroup and http://asktom.oracle.com regarding LMTs, fragmentation, uniform size etc.
3. use LMTs in your databases
4. stop worrying about fragmentation

--
Marc Blum
mailto:blumNOSPAM_at_marcblum.de
http://www.marcblum.de