On what version are you? If 10g you can simply do
alter table XXXXXX shrink space cascade;
this shrinks, compresses extents, drops High Water Mark. Very handy for online object rebuilds...
Results 1 to 10 of 31
Thread: Datafile resize
Click Here to Expand Forum to Full Width