question

thecoop avatar image
thecoop asked

How do I drop an overflow segment from an IOT?

There's an ALTER TABLE ... ADD OVERFLOW command, but there doesn't seem to be a corresponding DROP OVERFLOW, and ALTER TABLE ... MOVE ... without specifying OVERFLOW doesn't seem to affect the overflow segment - is there any way of dropping an overflow segment without doing a full table rebuild?

alter-tableoverflowiot
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.