Téma: How to reduce subpartition size?

I have a composite range-hash partitioned table. The problem is the summary size of all it’s extents is too large because they have been created in a wrong tablespace (with uniform size 200m) and contain few data.

I want to reduce the allocated space by moving all table subpartitions into a new tablespace with a smaller uniform size: 8m instead of 200m.

But when I do ‘alter table TTT move subpartition SSS tablespace NEWTS’ then 25 extents are created in the new tablespace (25*8m=200m=subpartition initial size) so it does not reclame any space.

When I try ‘alter table TTT move subpartition SSS tablespace NEWTS storage (initial 8m)’ then I receive an exception ‘ORA-14160: this physical attribute may not be specified for a table subpartition’

Is there any way of reorganizing a subpartition with smaler initial extent size?
Thank You!!!

I didn’t find the right solution from the Internet.


Video ads