-db is 10.2.0.2... - got a segment wanting to extend... needs 50M - biggest extent in dba_free_space is 28M - i add a 250M datafile to ts - biggest extent in dba_free_space is still 28M - select bytes from dba_free_space for newly created datafile BYTES ---------- 29360128 29360128 29360128 29360128 29360128 29360128 29360128 29360128 27197440 9 rows selected. - there is my 250M fragmented - any ideas why i can't get my one 250M extent? - have tried this in multiple tablespaces with same result - creating a new ts looks fine... one extent sized properly in dba_free_space - dbms_space_admin was used to migrate all dict managed ts to local when moving from 9i to 10g a while back(didn't do ts reorgs) thanks -doug- -- //www.freelists.org/webpage/oracle-l