Path: imp.nntpserver.com!newsfeed-west.nntpserver.com!newsfeed-east.nntpserver.com!nntpserver.com!border1.nntp.dca.giganews.com!nntp.giganews.com!news.glorb.com!cox.net!news-xfer.cox.net!p01!fed1read07.POSTED!53ab2750!not-for-mail
From: anacedent <anacedent@hotmail.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.7b) Gecko/20040421
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: comp.databases.oracle.server
Subject: Re: avoiding tablespace fragmentation
References: <c06e4d68.0406060426.2ab5ccf0@posting.google.com>
In-Reply-To: <c06e4d68.0406060426.2ab5ccf0@posting.google.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
Lines: 10
Message-ID: <YZEwc.50386$oi5.24062@fed1read07>
Date: Sun, 06 Jun 2004 06:28:23 -0700
NNTP-Posting-Host: 68.7.204.31
X-Complaints-To: abuse@cox.net
X-Trace: fed1read07 1086528504 68.7.204.31 (Sun, 06 Jun 2004 09:28:24 EDT)
NNTP-Posting-Date: Sun, 06 Jun 2004 09:28:24 EDT
Organization: Cox Communications
Xref: newsfeed-west.nntpserver.com comp.databases.oracle.server:220064

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
define "tablespace fragmentation", please