Any single SQL clause to release the unused space under high water mark in table.

Hi, All,

  As I know, there is command "alter table "tablename" deallocated unused " which will release all the unused space above high water mark. However, as I know, there is not one to release the unused space under HWK.

I know, I can export or copy that table, truncate it, then import or recopy it to release that unused space.
However, since I am in production environment, we might lose data by doing this.

Any clues or suggestion to do this would be much appreaciated,

Thanks in advance,

Chuan Zhang Received on Sat Aug 12 2000 - 00:00:00 CDT