Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: avoiding tablespace fragmentation

Re: avoiding tablespace fragmentation

From: anacedent <anacedent_at_hotmail.com>
Date: Sun, 06 Jun 2004 06:28:23 -0700
Message-ID: <YZEwc.50386$oi5.24062@fed1read07> 





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
Received on Sun Jun 06 2004 - 08:28:23 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US