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 -> Defrag Tablespaces and pctincrease 1

Defrag Tablespaces and pctincrease 1

From: Scott T. Johnson <sjohnson_at_ibm.net>
Date: 1997/02/05
Message-ID: <01bc13b7$cdf54f00$454948a6@7l603>#1/1 







I am creating a new database and would like to create tablespaces
that are easy to defrag.   I once read that setting pctincrease to 1 in the
storage clause when creating the tablespace will have Oracle automatically
defrag the tablespaces.



Is there any truth to this?   What are the drawbacks?



Thanks,


Scott
Received on Wed Feb 05 1997 - 00:00:00 CST












Original text of this message













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