shrink和alnanly

  select  ss.blocks  from  dba_tables ss where ss.table_name='PROFESSOR_TABLE_BACK';     ----496

 

 select sum(bytes)/1024/1024||'M' from dba_segments where owner='TSSA' and  segment_name='PROFESSOR_TABLE_BACK';                                                                              4M

------------------------------------

SQL> alter table PROFESSOR_TABLE_BACK enable row movement;
 
Table altered
 
SQL>   alter table PROFESSOR_TABLE_BACK shrink space;
 
Table altered
 

----------------------------------

  select  ss.blocks  from  dba_tables ss where ss.table_name='PROFESSOR_TABLE_BACK';     ----496

 

 select sum(bytes)/1024/1024||'M' from dba_segments where owner='TSSA' and  segment_name='PROFESSOR_TABLE_BACK';                                                                              ---3.8M

-------------------------------------------------------------------------------------------------------------------

 
SQL> analyze table PROFESSOR_TABLE_BACK  compute statistics  for all indexes for all columns for table;
 
Table analyzed

 

select  ss.blocks  from  dba_tables ss where ss.table_name='PROFESSOR_TABLE_BACK';     ----471

 

 select sum(bytes)/1024/1024||'M' from dba_segments where owner='TSSA' and  segment_name='PROFESSOR_TABLE_BACK';                                                                              ---3.8M