Question: how to reduce hwm in oracle?
Answer: Just like after a flood -- you can never reduce the high water mark on a building, unless you rip the building down and build a new one. o in 8.1 and up "alter TABLE T move ....." followed immediately by an index rebuild of all indexes will do it as well without ever taking the data out of the table..