Database Administration (MOSC)

MOSC Banner

Space Not Raclaimed After Reorg

edited Jul 25, 2013 4:01AM in Database Administration (MOSC) 14 commentsAnswered
 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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center