Quote Originally Posted by PAVB View Post
I woud do alter table move partition pctfree (I don't like zero) update global indexes.

You have to rebuild locally partitioned indexes

Wether you move it into same tablespace or other tablespace depends on your particular scenario - available space and size of the target partition.
Paul,

can you expand a bit more on your explanation. My goal is to recover space
but when I change my pctfree my current partitions do not appear to shrink
nor would I expect them too. Would this change only help me going forward
when new partitions are created.

I looking to accomplish two things:

First, de-crease the pctfree since this table is never being updated.

Second, regain as much space for each partiton.

Can you provide some syntax that would accomplish both or am I
missing something.

Thanks in advance for your help