Space Not Raclaimed After Reorg
After table Reorg by the below method Space is not reclaimed.
For Partitioned Tables
1. Move the Table partitions
ALTER TABLE <TABLE_NAME> MOVE PARTITION <PARTITION_NAME> TABLESPACE XYZ ;
2. Rebuild Index
ALTER INDEX <INDEX_NAME> REBUILD ONLINE;
3. Gather Stats
exec dbms_stats.gather_table_stats(ownname=>'SCHEMA_NAME',tabname=>'TABLE_NAME',estimate_percent => dbms_stats.auto_sample_size,degree=7,granularity=>'GLOBAL AND
PARTITION',cascade=>true);
Can anyone suggest.
0