Oracle Database Discussions

Hi experts,

Oracle 10.2.0.2, having a question about the allocation of extents within datafiles of a tablespace.

I have a tablespace (LMT, ASSM), sized around 700 GB, divided into 20 Datafiles.
Each DF has a lot of freespace, between 1GB and 20GB (!). Now, I've "reorganized" a big table (size pre: 20 Gigs size post: 50 Megs) with alter table shrink space. Ran an analyze table compute statistics afterwards and additional reorged online with brtools within the same TS.

Okay, I'd say, the table (no lobs, no partitioning, just simple data) isn't big anymore and selecting the extent-usage from dba_extents tells me that the table has 64 extents but those extents are spread over almost all (!) datafiles of that tablespace.

Just for my understanding: why does this happen? Why not filling the datafiles one after another? The first DF of that tablespace has 1.6 Gigs freespace, a table with 50 Megs and 64 extents should fit in there, or not?

Thanks for your explanation in advance and best regards
stg