IOTable, Partitioned. Is it possible to MOVE only the OVERFLOW segments to another tablespace?
Posted on 2013-12-08
I wonder if I overlook something.
I would like to only move the overflow segment of a index-organized partitioned table.
actually, I had them in a tablespace with plenty of other objects, which have been dropped/moved, and now those segments are in the middle of the (huge) data files.
I would like to move them to the beginning of the files, so I could shrink the data files.
the ALTER TABLE ... MOVE statement allows to move BOTH the table/partition and the overflow, but I don't need to move the table/partition itself. just the overflow.
what would be the syntax, if any?
the version is 220.127.116.11 (and will be patched to 18.104.22.168 soon)