Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

When altering a table, which parameter indicates the number of bytes above the high water mark that the table will have after deallocation?

April 26, 2017altering bytes deallocation high indicates Mark parameter Table water

0

Posted

When altering a table, which parameter indicates the number of bytes above the high water mark that the table will have after deallocation?

1 Answer

0

Posted

KEEP To deallocate all unused space in a table above the high water mark, use this command: ALTER TABLE table DEALLOCATE UNUSED; To deallocate unused space while keeping a specified number of bytes above the high water mark, use this command: ALTER TABLE table DEALLOCATE UNUSED KEEP integer K/M; If the size specified in the KEEP option is below MINEXTENTS, MINEXTENTS will be kept.