View Single Post
  #4 (permalink)  
Old October 13th, 2004, 09:35 AM
Justin Cave Justin Cave is offline
Authorized User
 
Join Date: Apr 2004
Location: Boise, ID, USA.
Posts: 70
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Locally managed tablespaces (LMT) do not get fragmented and objects in a LMT tablespacs do not have a PCT_INCREASE setting. It sounds like you are describing a dictionary managed tablespace (DMT).

If you have downtime over the weekend, I would seriously and strongly consider migrating to LMT's.

Justin
Distributed Database Consulting, Inc.
http://www.ddbcinc.com/askDDBC