I also should have specified locally managed tablespaces with segment space management set to AUTO. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of ramick Sent: Sunday, June 25, 2006 7:21 PM To: 'oracle-l' Subject: resetting the HWM 9205 - RH Linux x86 Is there any way to lower the HWM other than truncate or drop? TIA -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l