maheswara.rao@xxxxxxx wrote: > We have tables that are highly fragmented. We are planning to reorg these tables... > Our aim is to reclaim the disk space and reset HWM. > > If we use Alter table move, does the HWM get reset Yes, alter table move resets the HWM. Between exp/imp and alter table move, the latter seems far simpler. However, it would be helpful if you could state more clearly what the problem is that you are trying to solve, what you mean by 'fragmentation,' and your version of Oracle. Depending on the version, there may be other options available to you that can minimize disruption. Please see: http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schema.htm#AD MIN10161 http://tinyurl.com/4a8emf Regards, Jeremiah Wilton ORA-600 Consulting http://www.ora-600.net -- //www.freelists.org/webpage/oracle-l