Inscrit le: 16 Oct 2017
|Posté le: Jeu 2 Nov - 11:04 (2017) Sujet du message: How to reduce subpartition size? Post Reply
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?
I didn't find the right solution from the Internet.
example case study