Re: Importing a compressed table doesn't go to smallest suitable free space

What I understand about Oracle using extents is this: if there is an extent exactly the required size, then us it first, if not, take a bite out of a larger extent, and then finally coalesce extents to try to find the correct contiguous space needed. You may want to pre-allocate the extents by building the table first and then use 'alter table... allocate...' to get what you need, or perhaps use some Oracle-supplied syntax along the lines of 'alter tablespace... coalesce...'. Hope this helps.
comp.databases.oracle
Alt.*.* Received on Mon Feb 19 1996 - 00:00:00 CET