Форум керамистов

Художественная керамика - форум сайта "КерамикАрт.Ру"

Вы не зашли.

#1 2017-09-05 15:07:24


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?

Please help...

I didn't find the right solution from the Internet.
Transportation Management Video

Отредактированно roberthans (2017-09-05 15:07:51)



Board footer

Powered by PunBB
© Copyright 2002–2005 Rickard Andersson


Rambler's Top100