I'm trying to compress the data into 1 extent.

I exported my table, disable all constraints....
truncated the table...
type - alter table TABLE_A deallocate unused;

I then ran:

select t.owner, t.TABLE_NAME, e.TABLESPACE_NAME, count(*) as cnt
from dba_tables t, dba_extents e
where t.table_NAME = e.SEGMENT_NAME
and e.segment_type = 'TABLE'
group by t.owner, t.TABLE_NAME, e.TABLESPACE_NAME
having count(*) > 2
order by t.owner, e.TABLESPACE_NAME, cnt
/

It still shows me having like 40 extents... how do I get oracle or dba_extents to update itself?

thanks.