ANALYZE TABLE BASEINFO COMPUTE STATISTICS;
select * from organizations;
SELECT blocks, empty_blocks, num_rows
FROM user_tables
WHERE table_name = 'BASEINFO';
alter table BASEINFO enable row movement
alter table BASEINFO shrink space cascade;
alter table BASEINFO disable row movement;
select * from organizations;
SELECT blocks, empty_blocks, num_rows
FROM user_tables
WHERE table_name = 'BASEINFO';
alter table BASEINFO enable row movement
alter table BASEINFO shrink space cascade;
alter table BASEINFO disable row movement;