extent_management = local allocation_type = user segment_space_management = manual thanks -doug- >>> "LS Cheng" <exriscer@xxxxxxxxx> 6/17/2007 3:02:45 AM >>> Hi You are probably using Locally Managed Tablespace with Uniform Size Extents (which happens to be 28MB?). Thanks -- LSC -- //www.freelists.org/webpage/oracle-l