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?
Click Here to Expand Forum to Full Width